George Gay later in his life would sometimes make an appearance at a Navy base. He had a story to tell. Sometimes an action that seemed futile in the short term has immense consequences.
The effort by the torpedo squadrons seems to illustrate that effect quite accurately.
https://www.youtube.com/watch?v=ajlKvA48IXU
John Ford who filmed the Battle of Midway was given access to the Torpedo 8 squadron before the battle and made a short film.
They were wiped out and killed at Midway with only Gay surviving.
He provided the above film in 8mm for their families if they asked, some took him up on the offer and tracked down people with 8mm projectors so they could see their family members in their last days.