Foundation Models for Public Health and Epidemiology: from Promise to Practice