This is a problem where we live too as it's a big tourist destination (west coast of the US). Under pressure from residents, local City councils are finally imposing lower limits on rental times, e.g. at least 6 months. But this is only part of the problem. Builders only want to put up MacMansions, not low-cost, social housing. Homelessness is out of control. Large chunks of the city are "ghettoised". (I remember I was shocked when my DH first told me, over 20 years ago, that such-and-such was 'a Black middle-class neighbourhood.' A what?) America isn't a melting pot—it's a mosaic. Members of different ethnic groups cling together and don't want to move elsewhere, even when they can afford to.
In Naples, Italy, which we know well, there were already protests back in 2018 with the slogan, 'Naples is a city, not a hotel!'. Frankly, I preferred the place before the cruise ships started berthing there and crowds of other tourists started moving in (and out, and in, and out, and... ), but at least the latter buy provisions, while each morning's cruise-ship tourists, of course, are all gone that same evening.
And before anyone hits back: when we go to Naples, we go for 11-12 months at a time, not a week. When we go away in the US, we sometimes use AirBnbs, but we are always quiet and respectful of our neighbours, and we make sure we contribute to the local economy as well, with plenty of purchases from shops, restaurants, etc. The town we visit depends wholly on tourism now, as its other traditional industry, fishing, is dead in the water. So to say.