The Church of England is facing a "time of reckoning", the lead bishop in charge of safeguarding has told Sky News.