There have been no large scale public housing projects in a long time. The only time those were a thing, they were driven at the federal and state level. It's simply not possible for local governments to operate at the scale and expertise needed for this.

The world is larger than the US - state and federal level public housing can be done and it can be done well, and at a scale it's only way it can be done. The fact it hasn't in the US doesn't mean it's impossible.