It lasted six years. That’s pretty successful. It will live long into syndication.
It will died and quietly be buried because it stunk.
The ratings were abysmal. In fact, it was THE worst rated show on that network it aired. I believe the show was losing money and they couldn’t really even give it away. There’s not going to be a syndication for it. They couldn’t even produce merchandise for it, which is a key staple of Trek (and has been a chronic problem for post-2000s Abrams era). An all-around disaster. I’ve never watched a single episode, nor do I ever care to. It’s not real Star Trek. That ended with Enterprise.