At the bottom of this lies the need for hard conversations and talk about the dreaded "trade offs."
As I said in a previous post, I'm sympathetic to the inhabitants of Cornwall, the Lakes and so on, but I think it's also fair to point out that the residents can be their own worst enemies sometimes, and are often extremely reluctant to admit that there are trade offs in life.
If you want your settlement to exist, it has to have means of providing jobs and incomes.
If you don't want to do tourism you have to do something else; that also requires building 21st century stuff like infrastructure, roads and factories. That won't be pretty and people complain when this happens.
If you want to preserve more of a charming fishing village etc. feel, tourism can be a good industry, but you still need to build enough accommodation for the people to stay in.
Accommodation takes up space. I see people in these areas getting angry about any building on greenfield sites, but also getting the rage about any building more than a couple of storeys high. Accommodation has to go somewhere!
It's possible to restrict cars (there are some "ultra-low-car villages" in Europe where cars are mostly garaged on the peripheries and motor vehicles within the village are mostly prohibited other than the odd genuinely unavoidable journey, which makes it far easier to handle tourists), but that means residents will have to abide by these rules too. Are they willing to do this?
If an area is serious about "doing tourism," it needs to ensure that jobs and incomes are provided year round by creating year-round facilities (eateries, spas, indoor pools etc.), yet I see residents in these areas getting the rage about facilities, swanky restaurants and the like: "Why can't people just be contented with what's here naturally?" Well, if you refuse to allow anything to be built and insist that "tourists should just be contented with what is here naturally," don't turn round and complain when tourists only come in the summer and the place clears out in the winter.