I doubt that this show would be very successful. Too much of the action is just a few people in a room talking to each other. While Foundation is very famous, it's not a very visually stimulating series.
This is why I think it might be really cool as a show. All the specifics in the books are totally glossed over, which means an adaption could really delve in and go much deeper, and render the material in a whole new light.
I'm hoping they don't even try to be especially faithful to the narrative structure of the books. The story in the books is so compressed they sometimes cover several years in a couple of pages. In the show, those years could stretch out over several episodes, or even several seasons..
They should just use the basic storyline and the vibe of the universe as a framework and build character drama on top of the bones.