I’ll bet his stateroom is right there at the impact point. There are four staterooms on the main deck, 2 on the starboard below the navigation bridge. He was probably asleep when the ships collided.
Not having been on an Arleigh Burke class, I’m guessing that is Officer Country.
The others could have been in the damaged and flooded accommodation spaces.
..makes sense..the bow of the cargo ship shows damage all the way up to near deck level