I think Star Trek is one of Paramount/CBS' more bankable franchises so will continue in some form. I think for the moment that will be on streaming. I don't think the movie format works particularly well given the size and ensemble nature of the cast.
As for the future, Discovery is closing out after S5. Not sure if they will try and spin something out of that. Maybe that rumored Star Fleet Academy series?
SNW will get another couple of seasons with Pike in command. After that I suspect it will continue with Kirk et al. If they are smart they will jump forward to the point just after The Motion Picture and pick up there. That gives them the opportunity to lean into The Motion Picture redesign to make it visually different from SNW and a fairly clear 5-10 years of timeline to fill before the red uniforms and ST:TWOK.
I think having 2-3 shows with 10 episodes a season and a season per year is probably the right balance.
A bit of whiplash from the switch in tone from the last episode but this was a masterpiece. Strange New Worlds seems to be successfully synthesizing all the Trek shows that have gone before it to create something that is classic Trek, but also something new.
I wonder if the first episode of the season would have worked better if this had been before it in the running order?