Just a comment on the value of the Monarchy to the country. It is estimated to be about £1.7bn, of which £550M is from tourism. The rest is patronage, Royal Warrants etc. The annual value of tourism to the UK is estimated to be around £150bn, so it wouldn't be a disaster for tourism or the economy in general if we didn't have the Monarchy. Incidentally, for scale, angling contributes about $1.4bn to the UK economy annually.
I'm not a royalist. We need to fund a head of state somehow and I don't have strong feelings about how we do it. The alternative to a monarchy isn't a US-style presidency, it could be an Irish style presidency, if we wanted one. But the population would rather have as a figurehead someone chosen because their ancestor used to be the butler to the King of Scots in the 12th Century, irrespective of what that person is like.