That’s the question for Andrew personally. It’s not the question(s) that the monarchy has to address. At present, the Queen is using her money and power to foot her son’s legal bills and protect him from awkward questions from the press (and some would say, from the law, if only an embarrassing photo of Andrew being served with papers). The money is “her” money, but the public may not see it that way, particularly younger people.
It's hard to see a good way for this to end for the royal family, except in Andrew’s exoneration, which seems distinctly unlikely. It’s madness that he still retains his honorary military roles and if what I’m reading about the Queen wanting him to stay as colonel of the Grenadier Guards is true, the madness is multiplying. If it’s true that Andrew is her favorite son, it’s shameful for him to be hiding behind a deluded mother’s skirts, and if she’s protecting him in full understanding of the embarrassing and insensitive things he said in his own defense...….this is not good.