The titanic has sunk is a reference to when the dick has stopped being hard and has gone back to normal. It is usually the girlfriend/boyfriend who say it
Girlfriend: Hey are u ready.Boyfriend: No sorry babes.Girlfriend: Has the titanic sunk.