Campbell Wilson has resigned as CEO of Air India, citing the need for new leadership amid ongoing challenges for the airline.