The Naked Now, is the sequel to the Original Series episode, The Naked Time. Much like the original series episode, this one is full of cheese.
To be fair it is a good cheesy Limberger quality, because it's a hilariously bonkers episode. However in a show purported to be more high quality in comparison to its predecessor, this one just doesn't feel right.
The best way The Naked Now works, is if we already know and love the characters. This being the second episode of the new series, we haven't really gotten a chance to know the characters yet, which can lessen the impact of the episode for some.
However it should be noted that its predecessor, The Naked Time, was the fourth episode of the Original Star Trek, which is still beloved by fans. Still, the humor in this episode seems too broad, and inappropriate for this cast, which is why it is not as beloved.