If the tale of talking snakes really showed what it is supposed to show, we'd see lots of nonreligious people refuse to accept evolution on the grounds that evolution is so absurd that it's not worth considering. That hardly ever happens; somehow the "absurdity" is only seen as absurd by people who have separate motivations to reject it. I don't think that apes turning into men is any more absurd than matter being composed of invisible atoms, germs causing disease, or nuclear fusion in stars. Normal people say "yeah, that sounds absurd, but scientists endorse them, I guess they know what they're doing".