One of Ireland's most senior Catholic clerics has called for the Church to take a "reality check" following the country's overwhelming vote in favour of same-sex marriage.