What you are referencing is the "Liberal Christianity" of the 1800's, but it is generally an unpopular set of views. Wikipedia's page is a bit short but a useful overview of the differences:
Unpopular in the US population, definitely. Unpopular among US priests, I wouldn't know, but I believe you. Unpopular among European priests… I would be much less confident.
The most brutal thing of all however is changing your mind. It tend to come with a terrible sense of loss, even though that grief is rarely warranted. Plus, many religious people strongly believe that religious belief is good, even when they're less sure about their accuracy. Tell them something convincing about God not existing, and they could panic. Most of the time, they will cling to their beliefs by sheer force of will.
Personally, I avoid that problem by noticing that I'm not entitled to my opinion. I'm not free to believe whatever I want. I just hope I'm strong enough to let evidence change my mind whenever it should.
By the way, Dennett talked about the reverse: how the Church itself lies: more specifically, priests won't try and correct the beliefs of their parishioners (like, such and such depiction of a miracle was actually just a symbol), lest they destroy their faith altogether.