The Bishop of Norwich has said he supports the Archbishop of Canterbury, Justin Welby, in his decision to resign over his handling of an abuse scandal.