The thing that doesn't add up is the onerous zoning restrictions. When you're limited in how many units you can build, and that total is lower than the demand for the highest-margin "luxury" housing, guess what gets built?

You can have exclusionary low-density zoning and homelessness, or you can have abundant affordable housing but residential areas are a mix of building types (SFH, MFH).