OTOH, it failed to explain why Picard's log (the unfalsified part of it) had Picard stating "May she find her way without us". This was in contradiction of the idea that Picard would have attempted scuttling, and that the attempt would have failed without Picard realizing it.
We don't really have reason to think that Starfleet Captains have standing orders to scuttle their ships when forced to abandon them. Scuttling has only taken place, or even been suggested, when it has provided direct tactical advantage (i.e. taken at least a few of the enemy with the scuttled ship) or acted as a means of blackmail. So Picard abandoning a more or less functional starship to her fate might not be that surprising after all.
Perhaps the idea was to have Starfleet recover the derelict later on, and it just so happened that the wreck had been stolen or otherwise lost before the tugs got to it? Perhaps that's what caused Picard to get a court martial - that he didn't leave a guard behind in a spacesuit to ensure a recovery? The "loss" of the ship that he was accused of wasn't the conclusion of the battle, then, it was the theft or misplacement.
However, that wouldn't jibe too well with Picard's last log entry, either. He seemed to fully expect the ship to continue a Starfleet-free existence. Which might not be such a stupid idea after all. Even if gutted with fires and totally out of working order, the ship might still serve as an uncrewed ambassador to the UFP; there would be few risks in letting random aliens examine the already grossly outdated derelict. If there really was sensitive material aboard, Picard could have duly scuttled
that, and not wasted time and effort in destroying the rest of the ship.
For all we know,
those are the standing orders of Starfleet Captains: to abandon their wrecked ships as monuments to the UFP. Just pull the pin on the beacon that starts transmitting a message of friendship.
Does it seem feasible that a Constellation class ship was still in service and on the frontier 9 years before TNG?
I guess so. That's only seventy years after the construction of the individual ship, apparently, and may also well be those seventy years after the introduction of the class. Kirk's ship was supposed to have decades of history behind it in TOS already, and the ship class then went on to serve for at least three more decades. If we go by the original idea of four decades of pre-TOS history, we have our precedent for the
Stargazer there already. Although more modern Trek has moved to assuming just two decades, and the 2240s launch date for Kirk's ship has been used on (barely readable) onscreen material, making it a bit unlikely that the class would really have started its life in the 2220s already.
Timo Saloniemi