John Aquila - At some point, Cognitive dissonance has its limits.
I really wish that someday we may eliminate a lot of knowledge gaps that God/superstition resides in. That eventually religions, supernatural, and other non-sense get relegated to a museum in the "This is how dumb we were..." exhibit.
I would hate to think that 500 years from now we will be fighting "holy wars" about "Who shot first? Han Solo or Greedo". I truly hope that there is a limit to Cognitive dissonance, as you stated. I truly hope that we manage to stay alive long enough that we will make a "brave new world".