I personally don't think that science is inimical to faith and faith-based values. It can be a magnificent way to explore the intricacies of creation.
You're probably versed in Ancient Near Eastern culture. There is nothing deceitful about a God who communicates with His people in a way they can understand, and in the ANE, that was through stories. Scripture has poetry, metaphor, song, prayer, and other literary "devices". That Genesis isn't literal doesn't necessarily disprove God's existence.
I think you're wise to be concerned about your children learning science. Children who aren't exposed to science and evolution might, as young adults, feel betrayed when they realize, either in college or by continual exposure due to their own curiosity, that science isn't the lie it was portrayed as being. In rejecting the stories they learned about creation, many reject other things about their faith as well.
I can't address rabbinical teachings, but I have been exposed to Christian creationists extensively. I'm bewildered by their general mistrust of science when it has clearly been beneficial in other areas of their lives. The cognitive dissonance that develops in intellectually honest people has lead many to a crisis of faith. In those that hold on to their creationist views, their distrust of scientists in general can also leave them vulnerable to distrusting science in medicine, etc.
It's not impossible to live in both worlds. Francis Collins, the geneticist who led the Human Genome Project, is a scientist of deep and abiding faith. There are many others. Maybe reading about them, and how faith and science coexist in their minds and lives, will help you to find peace in your desire to teach your children science. For me, the world would be a much less exciting place without it.
Edited to add:
How can I make my kids passionate in science and technology while spiritual and connected to Judaism?
The only advice I can offer here is to avoid making them mutually exclusive.
I started teaching my children about science well before they were able to read. There are so many resources available to help you teach science to children in a wonderful way. Speaking about it in everyday matters around the home should help, too. Kids are so naturally curious, it came pretty easily at our house.
One of my fondest memories in this area is their reaction on teaching them about gasses. That something invisible can have physical properties you can observe seemed almost like magic to them. But, unlike magic, the fascination doesn't dissipate when they learn "secrets" behind it. baking soda, vinegar, some containers, and candles are all that's needed for an amazing lesson!