It's like, by the time people began to realize that the show was becoming very promising, the plug was already being pulled. Real bummer.
Well, really there's no evidence to be found in the numbers that people
ever began to realize that - other than the folks who were still keeping track of the show and had been all along. Some fans
liked it better in the last year or so than they had before, but that doesn't mean that the larger audience that had deserted it ever showed an interest in resampling it or could have been persuaded to.
Actually, the number are whats up for debate as:
1) Only the first Primetime airing was counted.
2) While DVR numbers were starting to be tracked, they weren't figured in the same way they are today.
3) Sorry, one head guy can say 'cancelled' (ie Les Moonvies) and a show will go away UNLESS it's such an absolutely raging success that a paranet company intervenes. But generally, becase of the reorganization of paramount that was going on at the time; a lot of 'Trek' supporters in the corporate structure had moved on. nd hell we all know how well the 'rebranding effort turned out - they merged with the CW.
It's just a fact that post TNG - no Star Trek series had a lot of 'staying power' as they all started good (numbers wise) and bled viewers from the starting point on (yes, even DS9). TNG was the only Trek series to see a rise in viewership (over it's first season numbers) during its run.
And the funny thing is: I still think TNG had the WORST first and second season of any 'modern' Star Trek series - and hell ENT seasons 1 and 2 were better than TNG season 1 and 2; and ENT seasons 3 and 4 were BETTER than TNG seasons 3 and 4 from both a writing and production standpoint - yet TNG got 7 seasons and ENT 4.
For me, TOS is still #1; but I do have to say that overall, ENT was the one post 1987 Trek series that overall did the best at recapruring a lot of the feel that TOS had (imo). That may not have resonated with audiences the way it once had, but I will say overall that the writing on ENT (and especially in the later seasons) was not substantially better or worse than what had come before in the 35 years before ENT hit the airwaves.
FYI - I'm one of those 'older fans' (watching first run since 1969); and I have to say, that while I do love TOS, I also loved ST'09 (aka Abrams film); and thought it did do a good job at re-imagining Star Trek - and made a Star Trek film that was enjoyable and entertaing (and that's something I wasn't able to say about 3 out of 4 of the TNG era films; or STV:TFF; and a good portion of STVI:TUC in all honesty.)