I chuckled as i read this. The concept is interesting and definitely true: with covid, a lot of startups are no longer mandating that u need to commute to San Francisco, which was where all the startups used to reside.
So, the premise of bay area not being a hotspot makes conceptually ok. But, the Google, facebook's are still expanding and even though they are providing more options to diversity, it hasn't caught up.
Another thing is the california being immigrant friendly and weather being moderate. A lot of people don';t want to leave it here because of these, despite options like Austin and Atlanta (I know, i did consider them).
Detroit analogy can't be applied here for reasons like manufacturing did with costs being prime, foreign competitors like toyota and poor political policies lucrative to shift manufacturing to MX.
It will take another 10-20 years to even begin decline, forget becoming detroit. But silicon valley, being silicon valley has ample time to have another Google or Facebook sprung up.