It depends.
For one, white women are about the only group of women who Ive ever seen identify as atheists. Any (black) woman you want is probably gonna have a religious identity, particularly Christianity (or Catholicism for those in Louisiana/Haitians).
Ive necer necessarily dated a church going girl before to be honest, but the only woman I ever dated who Is call heavily religious was THE freak of my entire life. The one who fukked it up for every girl after.
She talked up God, Jesus and all that more than any woman I ever met and was also the most sexually open woman I ever fukked with. Go figure.
She was also an extremely nurturing, housewife type. Loved to cook and clean. Rejected any form of feminism. Firmly believed in serving her man. Not that I demand this kind of shyt from women, but I ain't complaining if you insist on it.
Basically everything you would want from a church going girl she had it, and anything you didnt care for she didnt either.
Except she was a broke jump off who dated me at the time because I had a good job and a car. Had kids. Was constantly pushing me to marry her and give her children. Also she was more than ten years older than me. I wish so badly that she had herself together.
On the other hand I've dated women who claimed to be Christians and claimed Christian values are important to their life, but its only important to her as a means of controlling the relationship and her partners. She selectively chooses when Biblical values are important to her relationship when YOU want something, but quiz her on anything in the Bible and she is lost.
I wouldnt run away from a sexy woman because she identifies with Christianity and her Church. But I cant go for controlling, phony Bible thumpers who only care about their status as "wife" and expect missionary sex for life.
Again, as a black man, I cant imagine identifying as an atheist or being with a woman long term who is one. No matter what I think having some typw of spiritual foundation is attractive. A chruch going girl can still be your girl, it just depends on what you want out of that.