So, I was in my 30s when O'Connor did her thing on SNL, and I definitely remember the context being discussed here in the US. There was a (brief) national conversation at the time about why she would do this, and a fair amount of attention on the 19th and early 20th century abuses by the church's schools and workhouses, where "women of questionable virtue" were held against their will and forced into labor. When O'Connor was interviewed about it, she talked about the abuse of women and girls.

I do agree that what the church calls "the crisis" -- the revelation that active pedophiles had been using their positions in the church to cover up their extensive crimes -- was not well known until the 2000s.