It won't be floating anymore, but it will at least be somewhat physically intact, at least relative to the state it was already in. It was pretty well stripped bare back in the 80s, and further gutted after that asbestos abatement project a while back. And it will be available for people who can SCUBA dive to visit.
The SS Australis passed through multiple owners until it ran aground while being towed near the Canary Islands and broke into two.
A sad end to a majestic ship.
One memory of the trip was the week in the Indian Ocean midway between Africa and Australia where the waves were so large the ship's dining rooms made the tablecloths wet to stop the plates sliding off as we tried to eat breakfast...
Some years ago I was on a cruise ship. The captain announced that they were changing course to avoid a storm. I was disappointed :-/
Although, I guess rogue waves can appear anywhere deep and rough.
The cruise ship will drive around the storm because it doesn't want the cargo to spill their drinks and get pissy. The liner has a schedule to keep.
Cruise ships today look like hotels mounted on barges [1]. About half the speed. A refurbished SS United States was never going to compete in that market, and plans to do so were never funded.
[1] https://www.royalcaribbean.com/cruise-ships/icon-of-the-seas
(not sure it should have been much of a surprise, jetliners were taking all the high paying traffic)