How many tourists actually got to even see the Queen, even from miles away? They come to see the palaces and castles which do not require a monarchy to be present. One of the most popular tourist destinations in France is still the Palace of Versailles and they haven't had a monarchy since 1792 so the tourist argument for retaining a monarchy is a non-starter.
I've always been indifferent to the Royal family, and it grates when they occupy so much of the news agenda - I have no idea (for example) why I am supposed to be interested when someone does something as normal as saying hello to someone or waves out of a window or car which, quite frankly, any human is capable of doing.
At least a "president" is selected by the people, which gives them significantly more credibility than an accident of birth. If the monarchy was disbanded there would be nothing stopping King Charles III putting his name forward to be president and if that is what the people wanted then he could become head of state on merit, rather than based on who his mum was.