Archbishop of Canterbury resigns as honorary assistant bishop after sex abuse scandal