Bishop of Newcastle condemns former archbishop of Canterbury, who also admitted ‘deep sense of personal failure’ about handling of allegations against Church’s most prolific abuser