I don't see that happening. Tech jobs aside, the Bay Area is still a very desirable place to live, and has been so long before Silicon Valley was a thing. Software engineers moving out of the area will create a gap that others will very happily fill in.
It is becoming less desirable imo. Wildfire season has replaced summer, crime and cost of living are out of control, and local parks have turned into homeless encampments.
