I agree the Captain’s Navy career is likely to be over with. That said, when accepting the position of Captain he has generally accept that most people know what they are doing. I suspect the XO and a few other department heads careers are over as well.
The Captain, the XO, OOD, JOOD, and CIC watch officers are facing serious career and legal consequences. There may be other enlisted supervisors that may be involved.