I firmly and honestly believe that part of that shows failure was simply that god-awful song. I think it immediately turned off Trekkers and regular humans alike. (I like the show, for the most part. I love the ship.)
Sorry... didn't mean to get all misty on you. I'll get back to dumb jokes now.