I think the Devastators suffered the highest loss rate of all naval types. It was virtually a one-way ticket every time. I think the mission you are referring to is the one where almost all of them were shot down without a single successful bomb drop, but because the Japanese Zeros were then out of place the few surviving TBDs were able to sneak in and sink 3 unprotected carriers.

No. The Devastators (TBD) had drawn the Zeroes down low, so when (by complete accident) the Dauntlesses (SBD) and Wildcats (F4F-4) arrived high overhead they were able to begin their attacks completely unmolested.

The 3 IJN carriers (and a 4th later the same day) were sunk completely by USN bombs (actually the bombs simply turned then into blazing wrecks) and Japanese torpedoes fired from destroyers (to scuttle them when the Japanese retreated).

No USN air-dropped torpedo hit any IJN carrier that day.