The trilogy has super frequent cast changes. They might be able to do a season per book, but even then some of the books go through way too many characters to be comfortable for a format like that. Maybe do like a three-part episode per section in the books, in a sort of mini-miniseries? That condenses the dialog-heaviness and allows for some emphasis on the "action", although it would still be very cerebral compared to most series these days.
If they start with the prequels, they'd have a more stable cast. Not to mention, the prequels have a lot more action-y scenes and are a bit more fast-paced. The main downside is that they might lose audience if they go through the prequels and then do the main trilogy; many people would find the later seasons excessively boring, I think.
So I dunno. I can see ways where it might work, but it would have to be well-executed and planned out thoroughly. I think I'm going to try to be hesitantly optimistic, haha. We'll see what happens.
http://www.screenwritersutopia.com/article/d19127d8
Interestingly, the article discusses how the same scriptwriter was involved in a Foundation adaptation, (that didn't seem to go anywhere.)
Honestly, I'm more concerned with the scale of the Foundation universe and timeline. If it's not well written and presented, viewers will easily lose track of the where and when.
My expectations are low, unfortunately.