Brand new market-rate housing is rarely "affordable", just like new cars aren't, but the economic research is very, very clear that it creates "moving chains" that fairly rapidly do have effects on the overall market:

https://bendyimby.com/2024/01/01/housing-supply-and-demand/

Agree with everything else about NIMBYs.