Foundation is not a faithful adaptation of the books, but the show is at least internally consistent.

Based on OP’s description, it seems like there are a few things that viewers of the Dune series will have to suspend their disbelief on, or else it may fail to meet logical consistency with the newer movies.