By the late-24th-century era of Star Trek movie. Star Trek: Picard establishes that Jean-Luc led a historic mission to save the Romulan people from the supernova, which was curtailed when the rescue armada under construction on Mars was destroyed by rogue androids. However, Spock himself took on the mission to stop the supernova before he vanished.
By combining the known sequence of events regarding the Romulan supernova, a timeline emerges: in 2379, the Romulan Star Empire's government was overthrown by a coup orchestrated by the Remans and they installed ban all artificial life in the galaxy and ended the Romulan rescue mission, citing a lack of both resources and political . Following this, the elder Spock vowed to save the Romulans in 2387. After all, Spock had been secretly living on Romulus trying to reunite the Vulcan and Romulan races since Star Trek: The Next Generation.
In Star Trek (2009), Spock's plan was to use red matter to create a black hole that would swallow the supernova, but the heroic Vulcan was too late to stop the exploding sun from annihilating the Romulan homeworld. Nero (Eric Bana), who believed he was the "last of the Romulans", blamed Spock for the doom of his planet and attacked the Vulcan's ship as Spock ejected the red matter into the supernova. The resulting black hole sent both Nero and Spock's vessels back in time to the 23rd century; Nero's arrival in 2233 caused the Spock (Zachary Quinto) before he died in 2263 at the age of 162.
Incredibly, the Federation (and Picard) in the Prime timeline are likely not aware of what ultimately happened to Ambassador Spock. Although Starfleet knows about the Romulans center stage.
It's quite sad that Starfleet in Spock's proper timeline likely has no definite closure to the Vulcan's legendary career and he's probably listed as "Missing In Action/Presumed Dead". Considering Spock's eminent status in Star Trek, his death is arguably more unfortunate than James T. Kirk (William Shatner) dying on Veridian III in Star Trek Generations because no one in Spock's own timeline even knows what really happened to the Vulcan. But perhaps the truth about what happened to Spock will finally emerge in Star Trek: Picard, and the Vulcan can be ed properly by Jean-Luc, who is now one of his oldest living friends.
Star Trek: Picard streams Thursdays on CBS All-Access and Fridays internationally on Amazon Prime Video.