At St Patrick’s Cathedral, the largest permanent artwork commisioned in its 146-year history is a plea for acceptance and community at a difficult time