It's absolutely realistic, and the fact that you're writing it off so quickly shows your ignorance. Social housing is successful in many parts of the world. Look at Singapore, for instance.

Mandatory parking minimums are going away in cities across the US, and units are getting more housing as a result.

Washington State is considering removing single family zoning.

Cities like Paris have many smaller apartment complexes that are public housing.

Everything I've suggested either exists or is being discussed seriously in some capacity. But, by all means keep your head in the sand rather than try to engage with actual housing policy.