So this idea of a totally isolated bubble is a fiction made up on few facts to sell a story.
And most people are fairly tolerant - except of the intolerable few who wish to destroy tolerance. Again more made up stories.
If that's not a bubble, I don't know what is.
In addition, Bay area people are from all over the country and from diverse backgrounds.
In contrast, rural communities tend to be highly homogeneous both in terms of race and life experience.
And sure, people come from all over the country, but they gravitate here because the SF bubble aligns with their own views. And if your views don't align, you learn pretty quickly to keep your mouth shut.
And sure, rural communities have their own issues, but you can have a much more diverse perspective going to any number of "fly over country" cities in the US.
Are you really surprised that sharing a party with white nationalists makes you an outcast in a city as diverse as San Francisco?
[1] https://en.wikipedia.org/wiki/Demographics_of_San_Francisco#....
SV had become a total thought bubble, with the average tech worker having either no conception or a very negative conception of how most of the country lives outside of the large urban areas.
Moving into areas with lots of moderates or conservatives will be a good learning experience. I don't expect people to change their ideology, but I do expect much more tolerance from them than what I've seen in recent years.