It's going to be Pike post The Menagerie in the far future.
The Talosians are long dead despite Pike's efforts, and he is rummaging through their tech trying to get off the planet/die. He inputs the data for Earth, but since he failed Astrophysics in the Academy, he messes up and goes to WW3 Earth in front of a Church. He panics and accidentally transports them all to Terralysium.
He realizes he was the Red Angel all along and proceeds to cause the rest of the 'Red Bursts'.
Spock and Burnham will eventually speak with Old Pike who agrees to keep it a secret from young current Pike. They convince Starfleet to issue a ban to the Star Group Talos under the penalty of death.
KIRK: What every ship Captain knows. General Order 7, no vessel under any condition, emergency or otherwise, is to visit Talos Four.
MENDEZ: And to do so is the only death penalty left on our books. Only Fleet Command knows why. Not even this file explains that. (unlocks the magnetic strip) But it does name the only Earth ship that ever visited the planet.
KIRK: The Enterprise, commanded by Captain Christopher Pike.
Old Pike is the one who gives the idea to Spock about helping Pike in The Menagerie.
Spock was bound by time paradox to do it which is why he acted so out of character helping Pike under penalty of death.
Before Old Pike loses access to the technology, he decides to revisit 2257 Terralysium to meet with Jacob for one last time and retire.
Pike: "I hope we meet again, Jacob."
Jacob: "I know we will."
This will put a cap on Pike's storyline.
