The Grumman Avenger was replacing the outdated Douglas Devastator at Midway(Dawn Like Thunder) is a good book about it among other things about the battle. Torpedo 8 from Yorktown was nearly all destroyed. Some of those pilots were sent to Guadalcanal and flew as part of the Cactus Air Force from there. According to what I’ve read the only thing the Devastator devastated was the people flying them. The Avenger was faster more maneuverable and a much better plane. GHWB lost his two flight crew off Chi Chi Jima before he was picked up. They were trying to destroy a Japanese military installation relaying info on our bombers going to the Japanese islands. (Fly Boys). GHWB was game pilot back then.
And we Torpedo 8 (Hornet) losing all their planes is well known. But very few know that in the same attack, Torpedo 6 (Enterprise) lost 10 of 14 planes, and Torpedo 3 (Yorktown) lost 11 of 13 planes.
A total of 6 out of 41 aircraft came back from the USN Midway torpedo runs.