I have said before, and I still believed, that I think that the late Queen's long reign was harmful in terms of the institution's evolution. The monarchy needs to be able to change as society changes and it got stuck in a 1950s deference were the emphasis was on being seen rather than what you said and how you behaved when not in public.
In the age of social media image means nothing if people find you inauthentic. Sometimes the purity spiral that demands 100% perfection is stupid because, let's face it, no one can ever reach perfection but on a more achievable level the demand for authenticity is helpful. It means that people can't just say things, they have to do them. We notice when someone is saying one thing and doing another. It opens up questions about use of funds and resources.
If we are to continue as a constitutional monarchy there need to be changes and I think Andrew is experiencing one of the changes. A minor royal can no longer be seen to be supported in luxury just because of who his mum was. Appalling behaviour will have consequences, albeit probably not legal ones which I don't think it's about his royal status specifically, in terms of titles and access.
It will be interesting to see how things go in the next few years.