Plus, people usually oppose nuclear which is an expensive but stable renewable option.
Some people call these people "the left", I suppose, in which case yea they're not much keener on new housing than the rich corporate conservatives.
Theres also an element by which it is driven by high prices and loss aversion. A new homeowner with a $300k house and a 95% mortgage is gonna locally fight anything that drives up supply and drives them into negative equity even if their sympathies do trend left. Nobody fights new development as hard when prices are lower, which is probably partly why NY's strictest rent control (which drives down prices) coincided with the fastest building in the 60s.
Without being snarky, the problem here is that there is a tension between what people believe in general, and what they believe about their situations specifically, especially when they have an incentive to feel the opposite way about it. For example, people may know (or believe) that building duplexes and apartments in their neighborhoods will reduce their property values, or "ruin the character of the neighborhood" and so oppose them.
They do lobby hard to remove building regulations in the name of building more affordable housing but they never actually build it unless local government actively forces them to with some of those regulations they hate, at which point they build the bare minimum and install a poor door.
What? Why would you think that?