The legendary ride took passengers for their last adventure this week