The narrator wants to see the ship sink in battle or a massive storm, resting at the bottom of the ocean rather than just being retired as a vessel. Since it had seen so much blood and action in its life, the narrator feels it deserves to go out in a blaze of glory.
