My dad was a Naval officer. Sleep deprivation seems to be a way of life in the Navy, and none of his ships ever had these kinds of accidents. He mentioned two specific ships in the Pacific Fleet that, around the time of the Gulf War, were generally known to be screw-ups. I’ll have to ask him which ships they were and check if they ever bungled like this.
Each ship develops a culture that seems to persist with the ebb and flow of individual crew members. Changing a culture requires an extraordinary level of attention, force, discipline and training driven from the top with the cooperation of some JOs and most of the goat-locker. Oh and firings. Massive firings.
You put men and a lot of gear together in complex situations, stuff happens... Heck, even in simple situations...
In a “Big” War all of these ships will be the first to go. With the age of satellites they cannot hide. And the missiles being built now could take them out in mere minutes. WWIII will not be fought with surface ships for very long. Anyone serving on them will be sitting ducks IMHO.