My observation about that is that it is not a cycle but a constant motion. It is a consequence of pushing boundaries. We push and at some point we push back after a certain line has been crossed. We will probably find a balance at some point, then probably push forward again.
I mean, it really depends on what circles you are in, in our algorithmic-gatekeeped world.
There was a bit of a movement in TikTok to get freaky stuff out of Pride Parades, for example, because the younger generation of LGBT has portions that are more prudish.