The Northern Ireland man previously said working on SNL was both “the most stressful week of my life but also ultimately really rewarding”