Part of the problem with "The Naked Now" is that it came far too soon in the series. It smacks of being a copycat and wannabe effort, right done to the title, at a time the series needed to be striving for its own identity. It also struggled with the cast not yet comfortable with their roles. Instead of being intrigued with its approach I found it embarassing.
If "The Naked Now" had been done in 2nd or 3rd season it likely would have come across completely differently.