The Archbishop of Canterbury's resignation following an abuse scandal was the "right decision", according to the Bishop of Oxford