I suffer this problem
I do live in Barcelona in a building where there are currently three flats operating for tourists fairly near a very well known landmark, so the pressure is really high on the neighbourhood.
Besides the skyrocketing prices (if I wasn't living in a property flat bought many years ago when they were still affordable I couldn't live there at all), another problem from tourist flats is one of noises and other misbehaviours. Loud night parties are a rule on these flats, and for those who have to work for a living it's a issue if you can't sleep well. Local police are routinely called but they never come.
However, this move will mean absolutely nothing, because all three flats are unlicensed and no measure at all has ever been taken to remedy them. For two of them the owner should be fined, but either they are not or the fines are being passed as a "operation tax" if fines are not high enough.
The third one is more problematic: the law only relates to landlords who directly operate them, but this is actually on a long term rent and those are who actually re-rent the flat as a touristic. In this scenario they're operating in a void of law: the owner is off the hook on this because his rent contract is allowed, and there is no provision for renters who re-rent: only the owner could do something, but if this assures him that rent will be paid and a bit more, he has no real incentive at all.
Furthermore, this coming from a mayor who, on the tenure of his own strong opposition to this kind of drastic measured when the former mayor pursued them (Ada Colau, you may have heard of her and her strong position against massive tourism), and the quite long term of the effective application of the measure, gives me zero confidence that that will take effect, not even if it would be effective.
Meanwhile, the insomnia days have already begun.