I read Foundation and its sequels as a teen, and I remember thinking it was pretty cool. More recently, when I saw that people were writing additional Foundation-based novels, I went back to reread the originals. What a disappointment that was.
The writing is really bad; Assimov had some good ideas, but should have let a writer put them into story form. The concept of psychohistory and predicting future events seems quaint now, given what we have learned about chaos theory (or sensitive dependence on initial conditions), quantum mechanics, and more.
I couldn't get through the first one without a deep sigh for my lost youth; then I returned them all to the library.
Whoever decided to adapt this for TV will have to rewrite so much of it that they might as well just forget using Foundation as source material and come up with their own plot, characters and narrative.