Ship carrying more than 4,000 people has limped into port in Alabama after drifting in Gulf of Mexico for days.