Patrick Kielty was visibly upset as he carried his mother's coffin during a ceremony that took place at the Church of the Sacred Heart in Dundrum, Northern Ireland, on Monday