Smith, who had been serving as Archbishop of Edmonton, was the general co-ordinator of the pontiff's July 2022 trip to Canada