they are addressing those issues in limiting short rent rentals. long term rentals are allowed and regulated.
But short-term rentals are basically identical with hotels which are commercial properties and have substantially different requirements - the people staying there will not frequent supermarkets, etc as much as they will restaurants, etc. They will not be sending their children to the local school, and so on.
Mixed use property can be (and should be!) encouraged, but it does have externalities that have to be handled and accounted for.