The leader of the Catholic Church in Ireland has said the Church felt a sense of “bereavement” at the result of last month’s marriage equality referendum.