The NHS "came close to collapse" during the pandemic, the chair of the UK COVID-19 Inquiry has said.