Personal, non-scientific observations from our small town in Michigan:
I don't know of anyone teaching the sciences in our area who holds what is commonly called a "creationist" (young earth, literal Genesis, anti-evolution) position. Neither do I know of any of them who are avowed atheists. I do know of at least a handful of public school teachers and administrators who are "creationists".
We attend a "mainstream" protestant church. There is nothing anti-scientific coming down from the denomination. But a substantial share of our local congregation are absolute Biblical literalists. There are at least thirty churches in town, and the greater part of them are "conservative" enough to be strict literalists. Some of those churchs are very small; I really don't know what percent of the local population attends them.
Our local representative to Lansing came stumping in our church at coffee time awhile back. He personally told me he would be combatting "this evolution nonsense" in Lansing, and asked me to remember him at election time. I assured him I would remember; I didn't elaborate.