Enterprise's self destruct acts like explosives are ringing the ship, which is a rather terrible design decision. Surely it'd just be warp core exploding. But the engine's are completely intact. It's the saucer section that explodes.
It's my impression that it's explosive, not a warp core breach like the one mentioned in TMP's director's edition. So yeah, it would kinda look like that.