The director of the Census Bureau must resign amid allegations of pressure to deliver immigrant count