Andrew is utterly gross and a total liability.
I wish he could be kept out of sight somewhere and removed from all sphere of influence, but it does strike me as quite a difficult situation to deal with.
I'm not really sure how much Charles can control Andrew's behaviour - he's a grown adult with wealth of his own who isn't a working Royal. It sounds as if Charles wants Andrew to downsize and live quietly, but Andrew is clearly resisting that strongly - if the stories about him refusing to leave the royal lodge (which he has a long lease for) and clamouring to be made a working royal again are true. He obviously has no sense of shame and a huge ego and sense of entitlement, so appealing to his better nature is unlikely to be successful - I don't think he has one!
I don't know if Charles funds Andrew now in any capacity, but it's clearly not enough for the extravagant lifestyle Andrew believes he should be living. But should Charles give in and increase his funding or bring him back into the fold to try and stop Andrew being such a liability? Personally I don't think so - i doubt anything would stop him and he'd just be given an even greater profile to merchandise. Plus he's an utter disgrace who should never ever be allowed to officially represent this country again.
I'd love to see the government take action against him though, if they have proof he's broken the law. I think official action is the only chance of him facing any consequences, as it seems to me the RF are between a rock and a hard place on the Andrew problem.