Catalonia is not only Barcelona. In Barcelona tourism is about third of city's income, so protests like this are ridiculous. Noisy tourists are usually in hotels/hostels. And I have to say locals sometimes are more noisy than tourists.
I completely understand the protests.. Tourists are a real pain in Barcelona, especially in El Born/Raval/around La Rambla.
I don't like drunk tourists either but if "tourists is a pain" for Barcelona - I will visit other cities, despite my huge love to Barcelona.
If oh are visiting someone's country, be respectful and polite. That usually includes not peeing on things :)
And I need to mention I've never seen disrespectful or hateful locals in Barcelona - almost every local citizen I met was kind and polite, even if our talk was possible only with Google Translate.
I have a problem with people who pee and shout in the streets.
Surely this is covered by some law which should be enforced with greater severity?
I think that the debate in Barcelona (and other cities) is a little more sophisticate of what your are implying.
There is a balance somewhere that cities have to find and this is what they are trying to do. Another consideration is that excessive tourism will kill what makes the city interesting.
It seems to me that you are demanding an homogeneous opinion from a few millions of people.
Also, tourists starting in AirBnB haven't been invited by the city -- they're outside the planned hotel capacity.