I don't know, if the Queen became frustrated enough with Andrew's lack of co-operation with the upkeep of Royal Lodge, she "could" have taken action to uproot him from the estate. Robert Hardman is credible source, as we all know. We'll never know as the Queen took that problem with her upon death. The press always stated the Queen would never take any measures against Harry and Meghan, she did.
We knew the security was going to go away, that was revealed this past summer. I'm sure Andrew has the money, not only from his grandmother, but I've always suspected he's still getting funds from the Middle Eastern and Central Asian sources. The trouble is, like Fergie, I have the feeling he spends as fast as he gets the money.