Busiek (of course) gives a good answer to this in an early issue of Astro City. The answer is, strict rationalism is even more important in a world where the fantastic is an every day occurance.
Further, Thor is basically an alien in the MU. Believing in him is not the same as believing in a deity who doesn't directly and obviously intervene in human affairs.