Speaking as an atheist scientist . . .
I would be deeply disappointed if someone gave up their faith because scientists tend to be less religious. I see absolutely no reason why the percentage of believing scientists should make you question anything about your religious beliefs (unless they directly contradict well established science, which is a different topic altogether).
Scientists do tend to be pretty sharp being that the profession requires a good education, life-long learning, and a propensity for analytical thinking. However, intelligence isn’t the same as wisdom. Scientists are really good at doing science, but they are as fallible as anyone else when it comes to the human experience. Scientists are really good at doing science, but not always that great at the human being thing.
However, the numbers you refer to do needs some sort of explanation. Science is applied skepticism, so it is a natural draw for skeptics which are made up of a disproportionate number of atheists. There has long been a tension between science and some theological outlooks, so it isn’t surprising if some potential scientists are pushed away from the sciences because of those beliefs. How many good and important scientists are we missing today because they happened to be raised in a church that strongly pushed YEC? For this reason, BioLogos is not only an asset for the Christian community but our community as a whole.
I would also suggest reading an essay by Dr. Francis Collins entitled “Faiith and the Human Genome”. Dr. Collins converted to Christianity when he was in college training to be a scientist, and he discusses how he is able to join his beliefs and science. I think it is right up your alley, and Dr. Collins also happens to be one of the founders of BioLogos.