There’s been a percentage of corrupt leaders in the Church for centuries. It’s not a new thing invented by McCarrick and others in the past few years. You could go back just in the last 100 years of US history and find a couple of archbishops whose actions were really questionable. (And you could also find some whose actions were really saintly and good.)
God protects His Church and the vast majority of bishops, archbishops, cardinals are good men doing the best they can.
Also, and this may be hard to accept, just because a person commits sins, even serious sins, doesn’t mean that he might not have also done good things in his life or that he said/ did nothing of value. People aren’t “totally good” or “totally bad”, they fall on a spectrum and no one is without sin.
I personally find this McCarrick business sad, but largely irrelevant at this point because the man has been out of office for over a decade. He’s just another symbol of the Church coverup of sexual abuse, which had been going on for a really long time and which I heard about way back in the 90s. I would certainly hope the Church is more cautious today and since we seem to see much more swift legal action now in the event of an accusation, it seems likely that things have changed.
Instead of worrying about what leaders are doing, ask yourself what you yourself can do to be a better person and how you yourself can help the Church. Even if you just pray for the Church and its leaders, that’s a positive action.
You could also focus instead on thos Church leaders who are saints or on the path. Such as Saint John Neumann (who was Archbishop of Philadelphia), Venerable Archbishop Sheen, and Servant of God Terence Cardinal Cooke. It’s highly unlikely that any of them did anything questionable. Otherwise, they wouldn’t be a saint or have a sainthood cause today. I find it interesting that Sheen had his ups and downs with Cardinal Spellman who definitely had some questionable aspects to his life, so you had good and not-so-good co-existing right in the same area of church leadership at the same time.