'Sorrow' after homosexual senior Church of Ireland cleric confirms civil partnership