As an aside, here’s an aggravating fact.
B-17 bombers were deployed against the Japanese task force at the Battle of Midway. Out of 322 bombs dropped, not one hit anything.
The be fair, most of the bombs dropped by high altitude bombers against pinpoint targets missed. To hit a small fixed target like a bridge took something like a thousand bombs to land one. High altitude bombing against an actively evading target was really a long shot.
One aspect of modern warfare that is under-appreciated by civilians is how precision guided weapons have revolutionized combat. Ships and planes used to bristle with guns and bombs. That was necessary because most of what you shot or dropped was going to miss. Today a single B-2 can accomplish what in WWII would have required hundreds of planes.
And Torpedo 8 scored no hits either and lost every plane...but they brought Japanese air cover down to the deck which let the dive bombers do their work.
I believe every bomb hit something called the Pacific Ocean