The Royals get paid for their participation in public duties. This is real work, but they also get a very nice stipend. That used to be funded by the government through the Civil List, but now the money comes from the Sovereign Grant, which is her share of the profits of the Crown Estates. She uses this money to fund the Royal enterprises. The Duke of York has been on the payroll. My guess is that he won’t get paid by the Sovereign Fund anymore. If he gets any money, it would have to come from the Queen’s private funds. He will have to go to work.
Tourists are money.