I think it is achievable. But someone has to start doing the economic planning to make it happen in each local area.
One approach is to take political control of each city and resolve the problem by applying sufficient government. Either you make enough housing for the people who are there, or you seize enough stuff for the project that people start leaving. But that can be hard to muster the political will to do.
Alternatively, "housing" per se is not unaffordable: at whatever reasonable fraction of a normal wage, there is somewhere on Earth that you could pay to live. Plenty of empty space in small towns scattered across the US, for example. The problem is that you can't actually live there, because you also need to have a job to pay for the housing, which isn't where the housing/empty land is. Also many of these places are so under-served by municipal services as to be practically uninhabitable: you can afford an RV and you can afford an acre of desert with no electric, water, or sewer service, but you cannot combine the two to create acceptable housing.
If the people who control the cities where the work and services are are unwilling to accommodate residents, then work and services need to be organized in places not under the control of these malicious actors. Ideally with new mechanisms in place to prevent the same failure modes from reoccurring.
Beans and a shack is probably actually an acceptable standard to guarantee everyone. And given enough time and spare bits of wood you can make your shack a good shack.
But right now a lot of people are suffering without their beans and shack.