The notion that the British Monarchy themselves bring in lots of money due to tourism is false
Buckingham Palace and the many other historical sites are the real things which bring in money and its not as if people will stop visiting them if the monarchy is abolished.