I hesitate to enter this but as someone who lives in an area infested with holiday and second homes I have a different take on this.
Holiday home tenants generally bring all their food etc with them as it is so much cheaper. They do buy from the tourist tat shops which are there to fleece all tourists and some do go to restaurants and pubs.
The tenants generally have no social awareness and cause problems with local residents as they consider they are doing us a favour and can do whatever they want regardless of local residents who should really just go away and stop expecting to live as they did before they graced us with their presence.
The houses are bought at higher prices than local workers can afford and lie empty all winter anyway.
We managed to exist pretty well before the vast increase in such homes and now I feel I am being driven out of what has been my home for 50 years due to the behaviour of tourists in general and some nearby holiday homes in particular.
They should be taxed to the hilt and a strict low percentage of houses in an area should be allowed as second or holiday homes.
I understand local home owners not liking tenanting housing, holiday homes or second homes.
Second Homes:
I can also see the logic is taxing Second Homes "to the hilt" (although as second homes don't use much in the way of local services, they are already paying a lot more tax than they use)
Tenanted Homes:
If you get rid of Tenanted Homes, where do you propose the occupants live ? other than NIMBY (Not I My Back Yard) of course!
For a lot of people rental of a home makes more sense. Not everyone want to buy, particularly if you are only in that place for a few years at most.
Holiday Homes:
If you get rid of the holiday homes, then the only places for the people to stay will be Hotels, B&B's and campsites.
Hotels are out of the price range of many, especially UK hotels which unlike their cheaper Spanish counterparts don't offer much in the way of facilities, pools, guaranteed sun, all day cheap food and drink, kids entertainment etc.
B&B's are becoming a rarity, as not many people want the trouble of running a hotel without the benefits.
Camp sites are not for everyone, and are only seasonal.
If you get rid of the holiday accommodation.
You will also get rid of the holidaymakers.
Which will take your local area back to as it was before the arrival of the holidaymakers, a poor, depressed agricultural/fishing society with no facilities.
There are plenty of places where you can see what happens where the holiday support is removed, I'd start with Barrow in Furness as a start.