Welby had faced intense pressure over his role in Church of England’s failure to halt years attacks by child abuser