The embattled CEO insisted the future is bright for Sainsbury’s and this week vowed to stay for “months and years”