There are also plenty of entrepreneurs and hackers and so on who move up here, so that balances things out to some degree. Still, though, California's NIMBYism has repercussions throughout the entire west coast.
It's almost as though people don't realize that lots of small things (like local zoning for example) add up to all the big differences that made the place so attractive that they moved there.
Specifically with regards to a bunch of retirees moving in, I'd take that over young couples any day of the week. People raising family will have much more impact than people who just want to enjoy retirement.
To me it certainly seems worse than other retirement approaches. You are forced into making a single asset a huge percentage of your net worth, which utterly destroys your diversification. Real estate is also notoriously illiquid, so if something forces you out of the area, you could take an enormous loss.
If someone proposed another retirement investment strategy with these characteristics that didn't involve your home, people would say, "I'll pass... that sounds like a really bad deal."
Let's say you buy a house at price 100, and the market doubles bringing the price up to 200. If you then sell and move into a house that was 120 and is now 240, then you've got to find 40 extra for the upgrade instead of the 20 extra you would have paid absent the price change.
That might hurt in the short-term, but in absolute terms your asset is worth a lot more, so you're winning. And depending on how much of your mortgage is paid off, you could be ahead in the short-term too; if you have paid down 25, when you sell you get 50 back to put into your new mortgage, and that more than covers the increase in cost of the upgrade (you got 25 profit from the market movement, and had to pay 20 extra for your upgrade, so you're up 5).
Not to mention that if you don't decide to move house, the nest egg that you're leaving to your kids (or sitting on until you downsize later in life) just doubled in value.
As you can probably see it would be easy to construct a set of parameters where the short-term price change hurts you (e.g. you're moving before paying down much of your principal), but property owners tend to be optimizing for the long-term gains.
Yes, lots of people plan to sell and move to a less expensive locale in retirement. Often, people who came to expensive places for good jobs but not because they had any particular desire to live in that place plan to return to where they came from in retirement. I've known lots of people from the Midwest working in CA where this is their plan.