I thought this episode was fun, and you can tell they tried to not take it too seriously. Musicals always have those over-wrought moments and songs that are just a bit too slow or go on a bit too long. This episode had that too.
It takes a lot of courage to do a musical episode, and I honestly thought I'd never see one in Trek, ever. They pulled it off just fine.