Justin Welby had tried to stay in post following the Makin Review but bowed to growing pressure over his position