I got to be honest, I find it kind of surprising there's no plans for anything else involving the Enterprise or Pike, considering how much money they've sunk into it. The Enterprise bridge is reportedly the most expensive set built for the show yet, the Enterprise crew got their own uniforms which have only been seen a handful of times, they've done up a special picture of Ethan Peck shaved and in uniform, despite the fact we'll probably seem him like that on screen for a minute or so, a well-known actress was cast as Number One and barely used, and last week they even made it a plot point that Culber is transferring over to the Enterprise. If indeed Disco is staying in the future from here on, which does seem to be the case, all this is going to be cut off from any future Disco episodes. I guess they can recycle the bridge set as some other ship's bridge or even utilize it in the Section 31 show (assuming that is in the 23rd century) but it sure seems like they poured a lot of time and money into the Enterprise, both ship and crew just to abandon them after the season.
Guess which ship Georgiou will be serving on next year of her show. The mirror universe Enterprise! Pike as first officer who will someday be captain only to be replaced by Kirk. Mirror Spock may or may not be their but mirror Culber will be. This is why they established a romance between her and mirror Culber. Also why our Culber has to leave. Actor can't do two shows at the same time. Maybe their mission is to stop the restiance movement which is now being lead by Prime Lorca who has made a new life for himself trapped in that universe.
Jason