Royalty in the modern world is mostly a tourist spectacle. They sell tickets to museums and raise money for charity. Andrew is an aging kid diddler. The type of people who donate to charity and go to state museums are rarely motivated to do so by aging kid diddlers.
Still, Andrew is almost certainly not getting up every monday morning to work a 9-5. Even if Charles doesn’t let him play royal, the royal family is still covering for him and supporting his lifestyle.
My sense is that Andy will not be enjoying his future lifestyle. He may wind up selling used cars.