Overall, renters in New York City suffer a loss of $178mm per annum, as the losses from the rent channel dominate the gains from the host channel. I find that the increased rent burden falls most heavily on high-income, educated, and white renters, because they prefer housing and location amenities most desirable to tourists. Moreover, there is a divergence between the median and the tail, where a few enterprising low-income households obtain substantial gains from home-sharing, especially during demand peaks.
That is from the job market paper of Sophie Calder-Wang of Harvard. You will note there still are likely net gains once you count tourist demand, but of course this helps explain why Airbnb rentals are unpopular in some cities.