Plenty of major destinations (holy places, resorts, etc) would bring in thousands of tourists at a time. The ancient Olympics, for instance, brought in tens of thousands of visitors.
The scale is massively different, they didn't have millions of people coming through a city during the summer, like Paris, Barcelona, or Lisbon gets. Just Lisbon gets some 5-6x its population as tourists per year, it's in a very different scale to some tens of thousands in ancient times, which wouldn't expect the same relative level of amenities as modern tourists do.
Firstly, vacation homes existed and were legal long before Airbnb - but finding one anywhere was expensive and a a massive PITA.
Secondly, who's social contract?
Also there is a reason why places places with lots of vacation homes are considered expensive an dnot the most pleasant to live at permanently. That's why cities etc regulated, they dis not want them to turn into holiday parks.
Some of the cabin rental companies I rent from have been around since the 90s.
The neighborhood social contract. The one where I know my neighbors and we build a vibrant community. Instead of the drunk idiots who show up for 3 days and throw their beer bottles on the ground.
What 'local norms' are so different that you won't understand them as a traveler? 99.9% of the population sleep and wake up at the same time. You just need to be a decent human being.
The hallways got scuffed up, some guests were excessively noisy, dropped trash all over the place, broke stuff... as a permanent resident if you do that you face consequences. As someone only resident for a weekend it makes no difference to you.
You aren't flipping it on its head at all, the reason hotels exist is because travelers exist and need somewhere to go.
Why does Airbnb think they have a right to invert the social contract that has created a designated place for people who are likely to not know local norms and be operating on strange hours?