Former bishop of Ferns, who had resigned over handling of abuse complaints in diocese, fondly remembered by mourners