It's not anti-housing. It's never anti-housing. Nor is it ever "neighborhood character" or whatever. The places that people are moving to have plenty of land to build.

What people don't like is that when upper middle class city and inner suburb types move in local ordinances that restrict what you can and can't do on your own land seem to always follow. And given a generation or so of change in that direction, it gets you the same overpriced, impossible to develop hellscape that those people were seeking to flee in the first place. This isn't unique to CA. Their stupidity isn't special. This pattern has played out all over the east coast and midwest.