Mad isn't it. 30 bedroom home that royal lodge is. Who needs a 30 bed home ffs. As you say, homeless ex-military on the street snd this bloke gets a mansion to live in, and now being offered Harry & Meghan's old home, which is also a mansion pretty much.
I think what gets me is the statement "the King is cutting the annual £250,000 subsidy that the late Queen gave to Andrew – meaning he can no longer afford the upkeep for the mansion."
So... the house belongs to the crown, and to maintain it Andrew was getting money from his mother. Now, at the age of 63 with no dependents living at home, he expects his brother to either maintain the house for him and let him continue to live there, or continue to give him a quarter of a million pounds each year so he can afford it.
He's going to be in housing funded by his brother regardless of where he is, why does he need the prestige of a mansion he apparently can't afford, paid for by others? Given he's now one of the dirty family secrets, he can't even claim he's working for his keep.