Why certain dioceses were rife with this heinous abuse (Baltimore, Boston, Pittsburgh, Newark, San Francisco (the anguish of
that particular diocese, so named)), as others were not, is something to investigate.
Man is broken, and the Church, in the time frame where abuse was most prevalent (and least "exposed") was infested with unholy men posing as priests with the intent to "prey" on innocent youth. Why the Church admitted these men is another matter to "scrape to the bottom of the pot."
Final judgement is not our responsibility. However, there is this, from Jesus' own mouth, from the Gospel According to Matthew:
"But he that shall scandalize one of these little ones that believe in me, it were better for him that a millstone should be hanged about his neck, and that he should be drowned in the depth of the sea."
This similar passage is in all three synoptic Gospels. (Matthew, Mark, and Luke).
The very notion of myself in a state of mortal sin is terrifying. Many people struggle with a particular sin, and go to confession with the sincere and earnest intention of "sinning no more," and that's another subset. No virtuous person knowingly and repeatedly places themselves in such a state, or in the environment that puts them in the occasion of sin. Priests who did so to this degree were never in the priesthood to lead souls to Heaven. Which, then, more disturbingly, reinforces the earlier point about their presence as priests and their ordination.
Other great saints have reformed the Church in the past when it has strayed from the narrow path. St. Augustine (himself no chaste man for much of his adult life), St. Charles Borromeo, and St. John Vianney come to mind.
Here's a transcription of a homily by a priest in Minnesota on the subject, delivered on 8/19/2018.
Link
He has been censured by the Archdiocese of Minneapolis for his outspokenness on the Archdiocese's "solution" to prevent further sexual abuse.
Link
As there are men who abused their station, there are also virtuous men who continue to uphold it.