Exactly. I truly believe half of Discovery dissatisfaction is because of not realizing what the show actually set out to do.
What's it set out to do, apart from having characters be tactless in how replicated matter is made out of shit? There's nothing to censor since that's actual verbatim dialogue from an episode. That's a way to win over children of all ages, woohoo! Even South Park would recoil in cringe.

Yes, previous incarnations swore as well. Despite being a lot less in frequency or in frivolity, with dramatic weight, refined context in which it was used, and there was still flak back in the day as well. That, or if there was when Picard made a dirty swear in French and nobody wrote in, the makers still seemed to realize it was crass and didn't keep the personality trait going? If so, it's not hard to imagine why. That's arguably a reason why the franchise has been fractured, general frivolity in a show that also has "DISCO" written on peoples' shirts - it's hard to take the show seriously when the show doesn't. It's almost camp except the show doesn't seem to know if it wants to be camp or serious. At least it knows how to be edgy for edgy sake.
Not for the squeamish or anyone who hasn't seen 'Red Dwarf" where they talk about "urine recyc" ever sixth or so episode, but as even ENT allowed more creative inference from the audience (they hint at it but weren't going to be so overt) as opposed to the tactless South Park-esque approach, which still doesn't work, this Trek devolution speaks for itself. Good acting by the guy, I'll admit, but Trek's capable of being a little less jocular.
The peach-floating-on-meatlocker-freezer palette was passe by 2007 too...
Reason(s) others have for not the show is/are their own.
Indeed, I'd dislike it more if the comment at the end of the clip didn't mention the lack of diplomacy and now I'm far more interested in Osyraa's character as a result. So it may be cleverer than many, including myself, are giving it for. (There's an admission few were expecting to read...) Yet South Park and Red Dwarf still manage to do better with the same sort of crude humor. But they know they're comedies. It's not easy mixing together genres and all within a single episode of a show...