Most people in the US live in “blue” islands even within “red” states. People live in cities (well, metro areas).
Do they? They tend to have cheaper housing in absolute dollar terms, but that has to be weighed against the job market - not for white-collar can-work-remote folks like us, but for folks at the lower end of the income scale in fields such as construction or retail. The OP cites results from Denver and New Orleans as well as New York and Boston. When it comes to homelessness, no state seems to be immune. I know people on the left tend to blame greedy landlords and developers, while people on the right tend to blame over-regulation and limited supply, but just blaming Biden (which satao did at the time I replied) without any supporting reason or facts seems like the kind of partisan pot-shot we shouldn't welcome here.
How long till the unstoppable wealth elevator strands enough people at the bottom who are both armed and capable of building effective resistance? Course such things wont effect this group on this site, so best to stay curious, sip coffee and watch.