Current users are sorta 50/50. There's a large contingent of fundamental Christian types on here who are morally against it and they'll certainly speak their mind on the matter. (Not hating, just stating facts)
The other half don't mind and are open to it. I'm sure there's a contingency of people who actively seek it.
My opinion is YOU DO YOU! If people don't like it they can simply mute you and you won't show up on their feed. Everyone gets what they want. That's the beauty of nostr.
From the beginning we've had nudity, porn, and all kinds of crazy stuff. Post anything you want because nostr is freedom.