Having a show be just on CBS All Access is a good way to get it cancelled. When they see how poor viewership is, they would either need to put it back on TV or can it. I find it hard to believe that they think they have enough content to get people to pay $6/month. At best I could see subscribing for a month or two and binge watching the show.
It's already started: the premier was preempted by the football game, and everyone in my office missed it on their DVRs. We all installed the CBS app on our Firesticks, and saw a free trial that would automatically start charging your Amazon account after a week.
Popped over to Kodi, watched both episodes in HD win no commercials.
Fans are not going to pay for one show. Ain't gonna happen.
I have a friend who's a huge Star Trek fan and subscribed just to watch it. He said it's so terrible he already canceled.
I'm not sure what kind of standards your friend has, but the show is far from terrible. It's filmed with the look of a big-budget film, the effects are amazing, and the characters...while a bit wooden...seem to have a clear development path. I suggest you watch it yourself before giving judgement. Discovery is actually better than the last couple of Star Trek movies so far.
What I did not like: The extended Klingon conversations. 10 minutes straight of "KIN GOK UK ROK IK NUK MUK KOW!!!" started to grate on my nerves. They handled this pretty well in previous movies by starting to speak Klingon and then meshed into English. The whole mind-link thing with Sarak was a bit corny too. On the whole though, the show was very likeable right out of the gate.