I agree but a direct adaptation of the books would not make a good TV show.
The books are a series of vignettes spaced decades apart with no continuing characters and each is a separate short story. While they work in the written form, they would not on the screen.
It could be done as a series of vignettes, for example, as 6 episode series, with each series centred around each crisis. That would give you 4-5 hours - or 2.5 Mrs Doubtfires - to do what Asimov does in around 60 pages (depending on crisis).
I don't understand the argument that this is impossible to do, pretty much every film you will have ever seen will have had a shorter runtime than 5 hours, and handled all aspects of character introduction, motivation, conflict, growth, and resolution, within than time too.
I am not saying it has to be identical or a word for word adaptation - I have no issues what so ever with gender swapping Hardin - but as another poster points out, having Seldon live on (other than as recordings getting increasingly divorced from reality) directly rejects the core premise of the book, which is a refutation of the great man hypothesis.
I tried to watch Foundation, mostly because Asimov is one of those writers whose style I can't stand in his actual books (his characterization is really flat--you could tell he was far more interested in his ideas and the characters were just pawns on a stage), and I've had a few cases where books I couldn't finish were very watchable on screen. Also, I was following Jared Harris from the Expanse to Foundation in the hopes of seeing something awesome.
But what I saw, and what I remembered from the books, didn't add up. Nor did it suck me in on its own merits, like some other adaptations have.
It feels more like an addition than an adaptation (it isn't, but it's the only perspective in which the show can be good). I'm a big fan of the books, and I'm also enjoying the show so far.
From the first season I thought the Trantor stuff was awesome but the Terminus stuff sucked. Never have I had a show where I was more divided.
I was this close to skipping the Terminus stuff, I just couldn't give a shit about it and was constantly waiting to see Trantor and the beefcake to do some boss shit