Archbishop Michel Aupetit had offered to resign after a conservative newsweekly accused him of badly administrating the local Church and of having an inappropriate relationship with an adult woman