Prices have doubled in the past 5 years. Because of Prop 13, if you've been an owner through this, you just stay where you are.
Then the whole question becomes making sure things don't change. I think it's just a bunch of lucky owners who bought here 20-30 years ago with no intention or ability to sell, and not much interest in building new stuff.
As far as stores of value, housing is a pretty bad one. It falls apart, is heavily taxed, and is relatively illiquid. I think you'd do a lot better with stocks, or bars of gold.
It is still unclear how economical this sort of automation will be in other parts of the world though. If it does turn out big, Silicon Valley will have a first shot at it.
It may be that certain jobs get automated. But look at what Tesla is going through; they're using more people, not less, and basically admitted they screwed up trying to automate so much assembly work from day 1.
On the other hand, the electorate here (SF) seems to want to push minimum wages to $20/hr, so maybe you'll end up right.