Like most reviews, i agree Foundation is not recognisable with regards to the source material other than a basic premise and some character names. Unlike the books it has lost it grand scale of the story (no matter how much they put into the visuals) and is just a bunch of small character driven side plots...worlds away from how the books read.
The series is warping into a Discovery Star Trek series...Mary Sue female characters, all males either evil, incompetent or sacrificing themselves for the greater good, it also shoe horns social justice elements that detract from the thin story as it is. Its another case of form over substance, the story lines are weak and nothing new.