I live in an area where there's almost no homeowner pushback to new housing. A lot of it is going in. Yet the housing market and property values continue to increase and record setting rates.
It's quiet far from the individual home owner that's driving these rates at this point. The closest I can blame individual home owners here is because they just so happen to always vote for big property owners. Most of my local politicians are landlords themselves.
At the individual-homeowner level, a lot of NIMBYism, HOA activity, and other toxic activity is grounded in "I have $400k of equity sunk into this square of land and it's the only meaningful asset I have for my increasingly oncoming retirement."
There are probably plenty of people who are subconsciously self-sabotaging due to that-- they may personally prefer a denser neighbourhood or more mixed-use facilities, but that Zillow number is blinking in their mind at the same time.
If the real estate were nationalized and people were leasing it from a state-owned trust, at basically its cost of operation (maintenance and amortized construction costs), it would free up a lot of resident income for other use or investment opportunities, and make a lot of changes less threatening to residents. (ISTR claims that rents in the USSR were on the order of 5% of income, and this when 30% or less was still a feasible story in the US)