The Resurgent-class Star Destroyer, unlike the Imperial-class, features a well-hidden secondary Bridge whose if the main Bridge is destroyed, it prevents the ship from having the same fate as the Executor, which is to fall on a planet or prevent the ship from becoming unusable.
So why was it that when General Pryde's Bridge was destroyed the ship started to fall and exploded on the surface of Exegol?