We learn in the Rise of Skywalker: Visual Dictionary that although the crew were evidently killed, the ship itself survived. With the dissolution of the Senate and the new-found power of the Empire, getting rid of all of the evidence was a low priority.
The Tantive IV was the historic Alderaanian consular ship that shuttled the Death Star plans away from Scarif after the Rebel Alliance's first victory. A faulty hyperdrive subsystem allowed the Empire to track and intercept it over Tatooine. The captured Tantive IV was scheduled to be destroyed as part of a falsified report to the Senate, but the Senate was disbanded within days and the ship's destruction was no longer a priority.
Eventually it made its way back into Leia's possession.
Leia has recently been reunited with her consular ship from her teen years, which was discovered moldering in a hangar in the Yarma system by a sympathetic former Imperial senator. It was returned as a gift.
According to the fully canon Star Wars: Ships of the Galaxy, the Tantive IV was destroyed by the Empire shortly after being captured. Given that none of the crew were able to be coerced into revealing the location of the Rebel base on Yavin, it's likely that the majority of its senior crew were killed during the boarding process and the rest of the crew were on board the ship when it was destroyed.