You're not describing cognitive dissonance. There's nothing inherently incompatible between free sharing and paid creators. It's hard, of course, but most economic issues are hard.
Irreconcilable even by a dictator-for-a-day? As far as I'm concerned the idea of a tax that funds content creation is a pretty good existence proof of reconciling those two ideas.