The footballing eco-system has a much more positive impact on the UK's economy than the Royals ever will. During the 19/20 season (peak Covid and a 'fallow' year by all metrics), the Premier League still had a contribution of close to £8bn to the economy (much of this coming from player wages tax...something that the Royal Family don't pay).
The other things you need to consider is that the oft repeated mantra 'but but the Royal Family bring so much in for toruism!' is more myth than fact. Most estimates put the tourism generated by the Royal Family at around the ~£50m mark:
Whereas the overall cost to 'keep' or 'prop up' the Royal Family comes in around double that amount:
These are eye-watering sums...to essentially sustain a family that provide very little return, and have little to no power. Why not abolish the monarchy, and pay them a civil servants salary if they need to cut a ribbon somewhere? I mean going by yours and other posters comments, that seems to be the main thing that they do.
Now the other thing to mention is that most of the revenues generated by the Royal Family tend to come from admission to various sites. If we were to abolish the Royal Family and make these sites museums or historical places of importance with certain protections, this wouldn't necessarily reduce the income in tourism. People still would come to visit Buckingham Palace, Windsor Castle and so on. Off the top of my head, the Royal Family own almost £14bn worth of real estate all divvied up in wider members of the family, which is ridiculous.