What you imagine or feel is irrelevant - if the housing you were in wasn't an Airbnb, it'd likely be occupied by a permanent resident.

That person, for better or worse, would be part of a community and contribute to it.

At some point, a community resembles swiss-cheese because so many people who would otherwise be in the community are absent because the housing they'd live in is absent. AirBNB's are just one part of this equation though.