That is where you'd build housing that lets people live closer to where they work, not where you'd built a high capacity train station to get people from a city center to city center.

What the bay area needs is a regional government that could set reasonable housing and transit policy instead of dozens of disjointed communities that only want office space and no housing and stand in the way of transit improvements.

There's no single solution that will solve the housing problem -- it'll take more housing closer to jobs, and better transit. (I purposely left out traffic improvements since that's a short-term bandaid)