After the publication of a damning report into a decades-long child abuse scandal, Justin Welby has bowed to pressure to resign as archbishop of Canterbury. Harriet Sherwood reports