This is exactly what's wrong with the Paramount+ model. The best it can do is produce Star Trek for people who already like Star Trek - there's not enough other content on P+ otherwise for anyone to pay for a subscription. Without Star Trek available on mainstream TV or major streamers like Netflix or Prime, so that people can stumble across it or dip their toes in without needing to sign up to a whole other streaming service, it's hard to see how the franchise wins over new generations of fans.
So best case, if P+ is the future of Star Trek, then the future of Star Trek has an expiry date.