I think it's right that they need to give Andrew something to do and a way to earn money, to keep him busy and out of trouble. We might think he can't sink any lower, but someone with an inflated sense of entitlement and used to living a certain lifestyle could be ripe for causing further embarrassment, especially after the Queen is gone. BUT it should be a private family matter, not a public-facing role.
He could be given a vanity management position on one of the private royal estates, where he can bark orders and take meetings and feel important, but doesn't actually do anything of consequence or have contact with the general public. Both of his parents lived into their 90s, so he's not just going to go away anytime soon. A proactive approach is clearly needed.