Well, yeah. That's kind of obvious. A large percentage of them begin to oppose the change, it's planly stated in the book.
"The waters which we spread upon the desert have become blood," The Preacher said, waving his arms wide. "Blood upon our land! Behold our desert which could rejoice and blossom; it has lured the stranger and seduced him in our midst. They come for violence! Their faces are closed up as for the last wind of Kralizec! They gather the captivity of the sand. They suck up the abundance of the sand, the treasure hidden in the depths. Behold them as they go forth to their evil work. It is written: 'And I stood upon the sand, and I saw a beast rise up out of that sand, and upon the head of that beast was the name of God!'"
"Thus it is written!" The Preacher shouted. "They who pray for dew at the desert's edge shall bring forth the deluge! They shall not escape their fate through powers of reason! Reason arises from pride that a man may not know in this way when he has done evil." He lowered his voice. "It was said of Muad'Dib that he died of prescience, that knowledge of the future killed him and he passed from the universe of reality into the alam al-mythal. I say to you that this is the illusion of Maya. Such thoughts have no independent reality. They cannot go out from you and do real things. Muad'Dib said of himself that he possessed no Rihani magic with which to encipher the universe. Do not doubt him."
Quoted from Children of Dune. <3 the Preacher.