A Carnival Cruise ship made a U-turn to search for a man who jumped overboard into the waters off Mexico ... and one of the passengers taking the trip told TMZ all about the tragic event.