This is actually what happened in parts of Westchester and Connecticut. All the executive staff were commuting from their suburban homes to their various headquarters in NYC, then they realized they could just move their office instead.
Obviously the Bay Area as a whole has a problem with housing prices. (It has for a very long time but it's become extreme relatively recently.) But one of the big issues with housing prices in "prime" cities is that professionals weren't clamoring to live in them until quite recently.
Look at Boston/Cambridge as well. Teradyne was probably the only significant tech company with a major office in Boston until the dot-com/bomb and it later moved out. All the growth in Kendall Square and Seaport is recent. It's no wonder urban housing and transit hasn't kept up.