The leader of the Catholic Church in England and Wales has apologised for child sexual abuse at the hands of paedophile priests after he was singled out for criticism in a damning report on Tuesday.