Not the Onion

When Jessica changes the water for the Fremen and they all get drunk on it, which should be a moment in this movie

No, spice orgy is one of the many scenes from books that got cut out in the movie. Interestingly, i noticed that Verhoeven read the book very throughly, but the book he read was apparently Messiah and Children, since a lot of scenes and few important characters are cut off, but there is A LOT of things that should be in the 1st book considering what happened in the books 2 and 3, but weren't since Frank Herbert did not plan the books, just wrote on the moment for the most time. Paul in the new movie very often sounds much more like the Preacher from Children of Dune than like Paul from 1st book.

they’re able to feel each other’s minds much like the BG can feel the genetic memories that are consciousnesses within them

Some people can predict the future there so why not limited telepathy

And in the books I feel like I recall they mentioned that this is when the older tribal shaman dies, and they feel her death here, and her consciousness then lives on within Jessica.

Yes, that is explained more in books 5 and 6. This was done by the Fremen, and then spread to BG when they started to use the water of life, but that require conscious effort of real Reverend Mother, and i meant the old non-RM memories. Also it would still not included death in most cases since it was done before every time.

Then again, the movies may go a different route and I may be off by a bit. 🤷‍♂️

In case of Ramallo scene the movie was exactly like the book.