The Foundation Trilogy - as a series of novels - is an all time classic of Science Fiction.
The Foundation Trilogy - made literally into a film/TV series - would look like a rip-off of the opening crawl from the The Phantom Menace that went on for 80 hours (of course, Lucas got it from Asimov, not the other way around...)
Seriously, I re-read it recently and it is 700 pages of stilted dialogue and exposition where nearly all of the action is sparsely described after the fact. Works for a SF novel because of all the great ideas (although the fundamental concept was pretty much discredited by chaos theory) - but many of those have now become SF tropes. Might work for a radio play (the BBC did that years ago) but it is going to need major re-imagining, a lot more show and a lot less tell, to make it into 80 hours of high-end TV. Frankly, it makes Dune look like an oven-ready screenplay.
Producing something "suggested by" Foundation rather than trying to do a straight adaptation is probably the best idea. That's worked well for a lot of "unfilmable" Philip K. Dick stories...
I'm excited to see it (hopefully Apple will have a new Apple TV then so I can buy one to get my free trial of TV+!) - but I'm managing my expectations.