I find it a little odd that the assumption is that single family homes are somehow always superior. That is not the case in a lot of the world. It’s not true in New York. It’s certainly not true in most cities outside the US and Canada. Perhaps instead of assuming everybody fits into this world view, we can accommodate other perspectives?
As for why single family housing is looked upon negatively, it’s simply inefficient. It’s inefficient for heating,for transportation, for land usage. It lends itself to cars more than public transportation, which, no matter how many teslas are sold, is a net negative. In my experience in the US, it also leads to enclaves, the so called gated community. I’m not certain if that’s just due to a history of racist housing policies or just a feature of suburbia but it’s worth noting.
That said I don’t think we’re in danger of eliminated single family housing anytime soon. Indeed the thing about single family housing is that it’s the easiest form of housing. Someone buys land and builds a house. It’s not so easy to make an apartment building.