The Airbnb isn't just about the cost of homes but also the comfort of people living in them. Would you want to live under an Airbnb? With the constant rotation of people, parties, etc?
I know it might shock many but a lot of people (I would say most) buy a flat to live in it and making it into a pseudo-hotel lower the quality of life at the benefit of the airbnb owner.
This is what HOAs are for. To ban the model of home sharing city wide is heavy handed if you're simple goal is to make existing tenants more comfortable. In a free market, people should be able to shop for what they want and make tradeoffs on the basis of price.