There is a saying - good books make bad movies and vice versa. I just don’t see the Foundation trilogy (and its follow-up books) making for good TV.
The BBC made a pretty good, 8-hour radio drama out of the first three books, back in the 70s. A talky series works well in a talky medium, though that’s no guarantee it translates well to a visual one.
Personally, I’d like to see them tackle the Lije Baley/Daneel Olivaw novels for TV.