You'd likely have already guessed but I'm not anti Royal. I'm not particularly pro Royal either though. I think they're pretty insignificant to how the country is run and have zero say in the decision making process as Johnson proved recently when he prorogued Parliament. Most of the Pomp associated with them is just that, but it does bring in the tourism. There are too many hangers on but, effectively, all the assets are owned by the state and the royal family are employees of the state.
Yes they live a life of enormous privilege, but as we saw with Harry, that all comes at a cost to personal choice and preferences. Dump the hangers on and what's left bring in enough readies in tourism and charity work to justify their existence IMO. I accept that's not a popular view on here.