It’s not that common in elite liberal circles, especially in the NE corridor and California.
Note that some people in this group do go to church, but it’s just not widely advertised and is typically not a central part of their lives (e.g.(compared to some places where going to church for some sort of event 2-3 times on Sunday and 1-2 times during the week is a thing).
Also note that every Ivy League school was founded around a church and the church-based seminary/school. The same is true of many of the elite feeder prep schools. Note that there is a church prominently in the middle of all of the campuses.
That said, rightly or wrongly, churches are associated with anti-science folks who are anathema to most academics and academic types.
It’s not. Even in Manhattan 45% of people attend religious services “frequently” or “regularly.”
37% of professors at elite universities are atheist or agnostic. Saying Harvard is friendly to the religious because it has a divinity school is like saying Stanford is a hotbed of the rightwing because of the Hoover Institution, except that you would expect a lot of atheists and agnostics at Harvard’s divinity school and no Marxists at Hoover.
I sometimes wonder if the US is less secular than Europe because atheists were for a long time associated with communists. Church going people obviously couldn't be communists.