At least judging from my model of American Protestants (which is mainly based on stereotypes, and hence likely to be inaccurate), Catholics say more reasonable things than Protestants (e.g. few Catholics deny evolution anymore), so the amount of compartmentalisation needed to stay a Catholic while supporting the mainstays of modern science is smaller than that needed to stay a Protestant.
A new study by the Pew Forum on Religion and Public Life [executive summary; full report; New York Times cover story] found that 19.6% of adult Americans answered a question about their current religion by saying they were atheist, agnostic or “nothing in particular.” In 2007, the figure was 15.3%; in 1972, it was about 7%.
Some relevant quotes from the executive summary: