I propose that the Enterprise-E became somehow entangled in something it could not be removed from. I have a mental image of the ship somehow stuck in “spatial quicksand” or maybe an infinite timeloop – some situation where Captain Worf saved the crew and the ship but then was not given the resources needed to extricate the vessel, leaving it to be abandoned in its place.

More heroically, perhaps the Enterprise-E “saved the day” by hooking itself into, say, the mainframe and physical hull of some starbase that suffering from some sort of collapse of software and/or hardware – saving the station from imminent destruction, but irrevocably welding the ship and station together. Again, perhaps Worf thought he’d be given support from Starfleet to eventually extricate the ship, which would explain why he would later feel justified claiming that the ship’s ultimate fate “was not his fault”.