Archbishop of York Stephen Cottrell says he is "deeply sorry" that action was not taken earlier regarding sex abuse by a priest in the Church of England.