I know for me, and this will sound petty, but it was the opening theme song. I remember tuning in with a group of friends for the first broadcast. We were intrigued by the opening but then when the Rod Stewart song that wasn't even sung by Rod Stewart came on it felt like Braga had lost his mind. They didn't even go a different route with it and have a woman sing it, or any normal man, they got a RS rip off artist.
I think the first few episodes were weaker than the norm also. ST was built on optimism and this show started out mired in self pity. The Vulcans are so evil, they hold us back, we are so weak etc.. Yes I get that this is supposed to be the start of it, but somehow the self pity just never worked for me. The second season reached back to a spirit more like TOS and things picked up. But perhaps at that point the damage was done? I know I never hated the show, but I never tuned back in either. I just never thought about it again.
On a side not, I didn't care for the last movie either for similar reasons. What's the future of the Franchise? I for one wonder if it's dead. Or perhaps it's just leaving me behind? Do people really like it or was it more of a "it's better than Nemesis" reaction?

