This cultural divide has deep roots in the power struggle that was created when the people who settled the Appalachian's figured out that converting fields of corn into distilled bottles of whisky was far more profitable since it could travel infinitely farther without spoilage along the trade routes.
They were "dirt poor" prior to this because they could generate fresh produce that had a limited scope and value on the market.
That's when the war on stills began and there was a very thorough campaign of misinformation about how "dumb hillbillies" were going to blow themselves up/make everyone blind trying to operate a simple still.
It was really about the potential shift in economic power if that region was able to leverage vast lands for growing and creating highly profitable alcohol that could be sold across the country.
That campaign/lobby was so effective that it still resonates to this day.
Also, totally get the condescension you speak of. "Oh. You do your own <plumbing,welding,lawn, automotive,...>! How quaint."
"rugged individualists" always seem to care a lot about how they are viewed by "coastal elites". We'd all be a lot happier if we cared less about how we are viewed by others.
I keep having this semi-irrational fear that the SV startup I work for will found out I'm not "one of them" and fire me for cultural differences.
Firearms are just one such cultural flashpoint, where "don't ask don't tell" is really the only modus operandi for those surviving inside the SV monoculture.
I wouldn't worry too much about a large influx of people, there's more than enough land to accommodate the little influx - there aren't quite so many people who move up into the mountains and those can make a decent community and a healthy local economy. You can even migrate further into the wilderness, yes it sucks that you are forced to but there's a silver lining to all this.
On your point about space travel, it doesn’t even have to be that far. The moon or mars aren’t that terribly far on conventional rockets. If we could terraform mars for our arrival, though, that would be cool. Maybe this unlocks another explosion of population growth, similar to the industrial revolution and improvements in medicine?
I love the mountains and freedom they offered me, the lessons they taught me, and the beauty and solitude from an exhausting world they provided. After the war when I became an atheist, I would tell others in the community when they asked me to go to church that the mountains are my church.
All that said, I doubt it will last. There is a huge influx of people (not just retirees, but refugees from the coastal cities) who would be considered rich into mountain communities, driving out the locals by prices and changing the demographic hugely. I keep a close eye on land for sale and land parcels that used to be huge are starting to be divided into 5 acre parcels and sold off... I can already see the distant future of this, turning mountain towns into you have to be rich towns like Aspen, and it makes me very sad.
I can't wait till we have independent space travel, which is when I believe the frontier spirit will be reborn again. Humanity will need it then again! Alas, I probably won't live that long.