As much as I hate that they're likely making it a CBS All Access exclusive, I do think this is probably the only way this show gets made. I really doubt any Star Trek (or any sci-fi) show would last in prime-time TV. I stopped watching mainstream TV, but it seems very rare for any new shows to get more than a season, and, with the possible exception of TOS, every Star Trek show has needed at least two seasons to start to get good (although I'd argue DS9 got moving much quicker).
I do hope they'll make deals with the other streaming outlets, as I think the continued fracturing of video content is only hurting things in the long-term. Bob does bring up a good point that I hadn't considered though. If you're willing to put up with hopping from service to service, you could watch all the good stuff from a provider for a month, then switch to another service doing the same. By the end of the year, you could probably watch every one of the exclusives that you were interested in. It's too easy to think of all these different subscriptions as annual things.
That said, if this does come on CBS All Access only, I won't be watching it unfortunately. We're still doing Netflix streaming + DVD to catch up on movies we're saving on by not going to the theaters, and I don't see that changing any time in the immediate future.