I have visited the Drum several times, parked next to the Battleship Alabama. It make for a fun day trip.They should take a page from the USS Drum playbook, and get it out of the water.
The ship that sunk at the pier was the USS Sullivan. They've pumped it out and have it back up, but with major damage.