Is this conflict "real"?
Nope. The idea that your brain's entire contents need to be self-consistent is just the opinion of the part of you that finds inconsistencies and insists they're bad. Of course they are... to that part of your brain.
I teach people these questions for noticing and redirecting mental muscles:
What am I paying attention to? (e.g. inconsistencies)
Is that useful? (yes, if you're debugging a program, doing an engineering task, etc. -- no if you're socializing or doing something fun)
What would it be useful for me to pay attention to?
Consider a concrete example: enjoying the sunshine. Enjoyment seems neutral. However, if I want to feel grateful, it seems I feel grateful towards something. I can personify the sun itself, or reality. It seems silly to personify the sun, but I find it quite natural to personify reality.
Is that really necessary? I have not personally observed that gratitude must be towards something in particular, or that it needs to be personified. One can be grateful in the abstract -- thank luck or probability or the Tegmark level IV multiverse if you must. Or "thank Bayes!". ;-)
For me, many of these muscles seem to require some extent of magical thinking. They generate a belief in a presence that is taking care of me or at least a feeling for the interconnectedness and self-organization of reality. Is this dependency unusual? Am I mistaken about the dependence?
Sure, there's a link. I think that Einstein's question about whether the universe is a friendly place is related. I also think that this is the one place where an emphasis on epistemic truth and decompartmentalization is potentially a serious threat to one's long-term quality of life.
I think that our brains and bodies more or less have an inner setting for "how friendly/hostile is my environment" -- and believing that it's friendly has enormous positive impact, which is why religious people who believe in a personally caring deity score so high on various quality of life measures, including recovery from illness.
So, this is one place where you need to choose carefully about which truths you're going to pay attention to, and worry much more about whether you're going to let too much critical faculty leak over into your basic satisfaction with and enjoyment of life.
Much more than you should worry about whether your uncritical enjoyment is going to leak over and ruin your critical thinking.
Trust me, if you're worrying about that, then it's a pretty good sign that the reverse is the problem. (i.e., your critical faculty already has too much of an upper hand!)
This is one reason I say here that I'm an instrumentalist: it's more important for me to believe things that are useful, than things that are true. And I can (now, after quite a lot of practice) switch off my critical faculties enough to learn useful things from people who have ridiculously-untrue theories about how they work.
For example, "law of attraction" people believe all sorts of stupidly false things... that are nonetheless very useful to believe, or at least to act as if they were true. But I avoid epistemic conflict by viewing such theories as mnemonic fuel for intuition pumps, rather than as epistemically truthful things.
In fact, I pretty much assume everything is just a mnemonic/intuition pump, even the things that are currently considered epistemically "true". If you'll notice, over the long term such "truths" of one era get revised to be "less wrong", even though the previous model usually worked just fine for whatever it was being used for, up to a certain point. (e.g. Newtonian physics)
(Sadly, as models become "less wrong", they have a corresponding tendency to be less and less useful as mnemonics or intuition pumps, and require outside tools or increased conscious cognition to become useful. (e.g. Einsteinian physics and quantum mechanics.))
Followup to: Do you have High-Functioning Asperger's Syndrome?
LW reader Madbadger uses the metaphor of a GPU and a CPU in a desktop system to think about people with Asperger's Syndrome: general intelligence is like a CPU, being universal but only mediocre at any particular task, whereas the "social coprocessor" brainware in a Neurotypical brain is like a GPU: highly specialized but great at what it does. Neurotypical people are like computers with measly Pentium IV processors, but expensive Radeon HD 4890 GPUs. A High-functioning AS person is an Intel Core i7 Extreme Edition - with on-board graphics!
This analogy also covers the spectrum view of social/empathic abilities, you can think about having a weaker social coprocessor than average if you have some of the tendencies of AS but not others. You can even think of your score on the AQ Test as being like the Tom's Hardware Rating of your Coprocessor. (Lower numbers are better!).
If you lack that powerful social coprocessor, what can you do? Well, you'll have to run your social interactions "in software", i.e. explicitly reason through the complex human social game that most people play without ever really understanding. There are several tricks that a High-functioning AS person can use in this situation: