The long and winding journey for the disabled Carnival cruise ship finally came to an end late Thursday night