While I understand it is non-standard, I am currently stuck with having a two person server, so this would certainly impact me.
And why do I have a two person server? Because we like to share things about a variety of subjects, and you don't really want to get a face full of porn in public transit, all because you got a notification about the noodles I had for dinner. It's something that has not been solved elsewhere (unless you want to deal with group chats as a workaround, but that's more of a hack than using a server for 1:1), so Discord was the better option here in that regard.
We have had similar reactions to things like tracking by websites and other such cases. And to a certain extent, I get it: sometimes you just want your tools to work and move on with your life. And if that means that something you don't particularly use or immediately care about is worse, then that's just the cost of doing business.
Specially around "NSFW", a lot of people just don't engage with it in "public". They leave "NSFW" stuff to one on one conversations with people they are close with, if at all.
The thing is, I say "NSFW" in quotes because we have seen, repeatedly, that what might be NSFW is not just porn. It has been extended to things around identify, sexual health and so on. Never mind that "you don't care about privacy" until you realize that you were in a data breach and you now have to worry about malicious people getting you into financial peril by abusing your identity. Or worse.
I'm not sure how you get people to care, though, before things get bad enough.