Archbishop Michel Aupetit of Paris is just the latest in a series of bishops who have offered to resign under a cloud, once again leaving the pope and the Roman Curia in a quandary