That is essentially it. The Stargazer was lost and as far as Picard knew, it was going to be destroyed.
How would that be compatible with Picard's last log entry (apparently not forged by Bok as Data reads it out loud, and Picard fondly embraces it)?
"We are forced to abandon our starship. May she find her way without us."
Picard, something of a disbeliever in afterlife, probably isn't speaking about how the spirit of the ship will find "her way" after the hull has been vaporized...
It instead seems that Picard did not attempt to scuttle the ship beyond what damage had already been done, and readily accepted that the future of the hulk might be full of surprises.
Is there any real indication that Starfleet would have standing orders to scuttle hardware that has to be left behind? When Kirk threatened to blow up his ship, it was a means of blackmail against enemies aboard the vessel, denying them the use of the ship there and then and not in some indeterminate future. When he did blow her up, it was to entrap and kill enemy troops to even the odds in an upcoming fight. So no proof for or against the scuttling of abandoned ships there.
In TNG, many a shuttlecraft crashed and was deemed unsalvageable. Yet only one wreck was ever deliberately destroyed - the one in "Skin of Evil", to prevent the entity down on the planet from repairing it and using it to escape. There was no evidence that the fallen saucer of the E-D would have been blown up, either, at least not immediately.
In DS9, runabouts left behind (say, "Battle Lines") were let be. The
Defiant self-destruct was attempted once, not to deny the vessel from the enemy in general terms but to stop her from performing an attack under enemy control.
VOY continued the tradition of leaving behind shuttlecraft wrecks. The ship herself was an important prize for the Kazon during the initial seasons, so Janeway was ready to attempt self-destruct for PD/political reasons - but only because she definitely knew there would be specific primitives coming to capture the secrets of the ship. Apart from that, abandoning of the ship never really made plot sense, except in "Year of Hell" where she was expended as a suicide weapon.
As far as we can tell, then, self-destruct is a good way to countermand boarding and commandeering attempts in certain situations, but far from an expected and dictated maneuver.
Timo Saloniemi