The idiom the ship has sailed dates to the 19th-century and means a missed opportunity. When ships sailed they used to move with the winds and the tides, so they could not turn back for any missed passengers. So if your ship has sailed, you've lost the moment to make an action or a decision.
He overslept and did not make it to the event, so that ship has sailed.