Terrifying video shows a storm flooding decks and hallways of a Carnival Sunshine cruise ship leaving passengers seasick