England's former Chief Medical Officer says "how sorry I am" to those who lost loved ones in the pandemic.