Their saying she was sunk in “Iron Bottom Sound” is misleading and perhaps intentional, though many US and Japanese ships are resting at the bottom of it. She was sunk during the Battle of the Santa Cruz Islands, https://en.wikipedia.org/wiki/Battle_of_the_Santa_Cruz_Islands
which are several hundred miles east of Guadalcanal and Iron Bottom Sound.
Also confusing matters is the ship renamed hornet almost immediately after the sinking.