Thing is, if we consider Trek relative to Star Wars and Marvel, it’s a commercial and marketing failure because I still think it’s perceived as being “uncool”.
Star Trek is an absolute popcultural juggernaut! Just going purely from hours of content, there is probably no other franchise that has this much high-profile hours on screen accumulated. And it has a very devout fanbase.
In fact, I would say Star Trek is one of the few overarching, big live-action IPs overall that people are aware of, like the James Bond franchise, superheroes, ... It is one of the only two(!) major science fiction franchises in the world (the other being, obviously, Star Trek) - all other SF franchises, be it Stargate, BSG, or Lost in Space are dwarfed by it.
But there is the thing: Star Trek is primarily a
television franchise. It's motion pictures, for the most part, have been glorified "The Movie"-versions of the show, and such the movie offshoots have never gained the same traction as whatever type of movie was the most popular at the time.
But I honestly can't think of a bigger, longer running television franchise of the top of my head. How many series does CSI have now? But they don't have the long history or popcultural penetration... Dr. Who? That's pretty long! But always was pretty much only "one" show, and the spin-offs clearly never matching the original. I don't know, maybe telenovelas. But Star Trek is
pretty big and durable, even if right now (as always has been) other things have been bigger at the same time.
Agreed. I loved Enterprise. It’s a shame it got cancelled - but even compared to TOS, it still didn’t have the same impact on either the viewers (fans or casual) or the franchise. So in that way it failed and led to the likes of Abrams looking at the “core” of Star Trek - which relates to the icons of the franchise: captain Kurt, Dr Spock, and the Star track Enterprise.
Oh, Enterprise was high-end production show that went more or less successfully for 4 years. In the realms of television, that's pretty good. It's only a disappointment in regards of
expectations - in that people had higher hopes for the franchise. The same holds true for DIS btw: Looked at it without context, it's one of the better shows out there. It's just under the massive weight of expectations from a new Star Trek shows that it crumbles under.