The infamous pop song theme for Star Trek: Enterprise was derided then and remains derided now. Here's the story of how it got from there to here.
Working from the oral history in The Five Year Mission: The next 25 years, this is a fascinating deep dive that answers the question “How did a recycled cover of a 1998 song written for Rod Stewart, ‘Where My Heart Will Take Me’ aka ‘Faith of the Heart’ become the title music for Enterprise?”
Also, after resisting melodic scoring in all the 90s shows, it turns out this was the music Rick Berman liked?!!
“…I, for one, can tell you that I thought it was a great opening and I'm not alone in that. I don't think I'm in the majority, but I'm not alone."
And it seems the song does have its own subniche of supporters who share Berman’s view. (But not I.)
The show is about humanity taking it's first steps into the wider galactic community, and the song is both about a journey but also less refined than other star trek intros, just like Starfleet is a less refined version of what we are used to.
I hated it until they changed it in season 2 or 3 and then I realized that I hated the new version even more and in retrospect the original wasn't quite that bad.