I don't think the Airbnb we stayed at in Charleston which was just this lovely lady's extra bedroom in her house really affected the local housing market. She doesn't want to rent long term and have to have roommates, she likes having guests and showing them around her city, and we're still friends several years later, so no housing is being lost, and it's actually a good experience. A single bedroom rental isn't a big deal to me.

I'm middling about the other Airbnb we stayed at, it was a sort of apartment, but I don't know who would have wanted to live there full time, the bedroom was only large enough to get a double bed in, let alone a dresser or anything, and we slept terribly, and while the kitchen and living room and bathroom were nice enough, there was no storage and a million stairs. The guy who owns it is a friend who owns the restaurant it's above and said he never has much luck with long term renters wanting it, as it is also noisy because of the location and smells of food all the time. I think a place such as that fares better as an Airbnb too. Short term rentals should not displace housing for sure, but I'm not sure they're all bad.