An alternative/additional solution to "just built more, denser housing" is making remote work much more widely adopted. A lot of roles in software, research, etc. are very well suited for remote work.
Bay Area companies should: (1) make remote work more widespread and (2) build more offices outside of Bay Area.
Yep - I agree with the increased dense housing is needed (although I would also argue that with this construction infrastructure / public transit comes for the ride or it is a failure too), but it seems that one of the stop gaps is to promote /incentive remote at companies...