Former archbishop of Canterbury admits ‘deep sense of personal failure’ about handling of allegations against Church’s most prolific abuser