That’s the funny thing. Foundation is actually incredibly simple to film - the whole book is just dialog between people with some simple descriptions - there’s barely a line of internal dialog in the whole first three books.
It’s just that audiences won’t put up with a completely new cast every 3 episodes.