Boris Johnson was left "bamboozled" by the science around COVID, according to the government's then chief scientific adviser.