The locals who dislike tourists are most likely not the same locals who profit from tourism. Wealth is too concentrated, that's also true for e.g. big hotels or shops in the picturesque old town. If every second or third resident had a room rented out to a tourist that'd likely be a different story. But same as always, some people profit, but all the people suffer the increased traffic, noise, waste, rent etc.