One of Ireland’s best-known priests has revealed the anguish the Church’s requirement of mandatory clerical celibacy has caused him.