I honestly don’t see much of a future for Trek in cinema. The first ten films had the gimmick of being glorified reunion films. The Kelvin films were Paramount’s honest stab at turning Star Trek into a tentpole franchise along with Transformers and the MCU (before Disney bought it up) but that didn’t pan out as they hoped, thus couldn’t afford to make a relatively less expensive film with the same cast.
Aside from maybe doing a Kelvin timeline TNG with Tom Hardy as Picard, I’m not really sure they can do much else. But I’m one of those weirdo fans that thinks Trek is better off sticking to television. It was fun seeing Trek dabble in films, but their real strength is on the smaller screen.
That said, I think it’s too bad there won’t be more with Pine. I wasn’t the biggest fan of the first two, but I adored BEYOND. At least they got to end it on a nice note, even if they fumbled big on marketing it.