The resignation of Archbishop Michel Aupetit was announced while the papal plane was flying from Rome to Nicosia