There probably are too many people in SF and spreading out would increase much needed housing supply in that market.
On the topic of property tax, that very well might be true for CA, although NY and TEX property tax seems similar despite the average home in TEX being almost half as much. https://www.rocketmortgage.com/learn/property-taxes-by-state. Additionally, there may be other cost of living factors that make TEX more or less attractive.