I don't think anybody was affected more by that abomination of a song than Jolene Blalock. She and her little outfits worked so hard to boost that show, and the producers threw obstacles like that song in her way. It's no wonder that she freaked out, quit acting, and married Ticketmaster.
There is a subset of Chief Petty Officers and CPO adjacent people who are Trekkies, and for whom O'Brien's rate and/or rank is... a fountain of disappointment.
Now, I can even explain the watermelon.