The theme is very controversial among the tv fans. It was a rock song that was superficially changed and renamed for a tv show. I'll take either version.
Looks like Faith of the Heart to me.
"Controversial," in this case, is a euphemism for terrible.
That was quick, Faith of the Heart is the Rod Stewart version. The Star Trek theme is Where My Heart Will Take Me. It is controversial because it is the only Star Trek theme with lyrics. Also because it's not a good song.
Your clues were very helpful in this case. Plus I must've heard that song hundreds of times.
Well, it's not a bad song...
Anybody can post a challenge.
The rules of the game are simple, take any song you like from any genre you want, put the lyrics through any AI [you may weight lyrics as the AI allows] that you want and post the resulting image here under the post title Name That Song [GENRE]. After 48-72 Hours or if the answer is guessed sooner, edit the post's title to [Solved][Genre] and put the song title and artist (and optionally any highlighted lyrics) in a spoiler tag in the body of the post.
Other than that, enjoy.
Here is a list to a few AI image generators you can use.