It feels like there's different restrictions pushed by different groups. Gen Z is pretty prudish and seems to be the most in support of some of the adult content or internet censorship, while anti-LGBT/bathroom policing/etc seems to be more of the older generations.
There was a pretty much instantaneous shift on a certain Tuesday morning in September of 2001. I haven't noticed much of a change since then. The whole national mood has been "better safe than sorry" for anything vaguely terrorism-adjacent ever since.