In the US, extreme violence has always been a lot more accepted than nudity. Which really says a lot about what kind of values the society has when completely natural human biology is shunned and anti-social destructive behavior isn’t.
That's true, but blasphemous content created a lot more controversy than sheer violence. I remember when D&D books were getting burned because parents thought it was satanist.
Cult of the Lamb is explicitly demonic and yet it's still the possible addition of sex that is creating all this hubbub. Personally I think it's going to be about as explicit as The Sims at most, getting in a sleeping bag and them some shaking and effects.
Cult of the Lamb was and still is massively controversial among evangelicals and other extremely religious/Christian people since it's so blasphemous. The falling number of Christians in the US combined with the echo chamber effect on the Internet just (ironically) means all the religious rage doesn't leak out and permeate all of society like it used to.