The fremen meticulously conserved and saved water to one day turn the planet into a habital environment. That's pretty hopeful, I think. Frank didn't really mature that arc of the story and instead focused, like you said, on religious fanaticism and dogma.