Architect and beloved RTÉ presenter shaped spaces for others but found his true home with husband, St Patrick’s Cathedral heard