The sexual revolution is intrinsically linked to the lack of community. The sexual revolution is not actually about free sex. People have been having weird sex for centuries; with or without their partners knowing.
What is novel about the sexual revolution is that it dismissed any needs for norms. Over the past two decades we've seen non-religious attempts to reinstate those norms (consent, kink, safe words, etc). However, what's unpalatable to religious people is not the sex per se, but the lack of norms.
And we need norms to function as a community with a common culture. Throwing those out does not actually help.
You mention the sexual abuse by the Catholic church, but that was caused by the sexual revolution. At the time, the psychological community encouraged moving pedophiles around. The church was -- at the time -- attempting to modernize, and part of the modernization was listening to 'science', including psychologists. Psychologists at the time insisted these things could be cured and criminalization would not help.
The church is not the only organization to have been affected by this, but it is one of the few prominent examples of institutions being held accountable for it. The same ideology caused the German foster care scandals [1] [2].
[1] https://www.newyorker.com/magazine/2021/07/26/the-german-exp...
[2] https://en.wikipedia.org/wiki/Helmut_Kentler