The principal issue, full stop, in the Bay Area and most of California is housing. There are two solutions to this: 1) Build more. But this is outrageously difficult due to a well-meaning political view of safety / fairness / etc. These restrictions employ an awful lot of bureaucrats for enforcement but add $10s of thousands in fees and delays for builders, that are IRR driven and would rather concentrate their effor…
Ending Prop 13 would eventually result in 20% of the state's homeowners being forced to sell and become renters. The US is full of affordable housing in places that are not (despite what you might think) utter cultural wastelands. Do not wait for Prop 13 to be repealed, you will be in your grave before that happens.
Have you considered that some people might be attached to locations in the urban core for pretty much the same reasons you're attached to those non-wastelands in Middle America? For instance, family history, or workplaces that don't do remote work.