The only way tent shelters will ever work without simply adding to the public health crisis, is to heavily legislate urban camping rules.
Make it legal to use an emergency outdoor shelter, provided it has a permit, to be renewed every week, confirms to size and placement regulations, is constructed from flame retardant materials, and (barring hazardous weather) that it's taken down every day from sunrise to sunset.
We then attach to the free permitting process, an identification check, automatic enrollment in welfare services, career counseling, etc. and immediate access to mental health and substance abuse rehabilitation.
Care for those who obey the rules and scrape up those that don't.
We can't just let people rot indefinitely, huddling half naked under a leaky plastic tarp, searching for that last good vein, and call it compassion.