I don't think the novels would've worked regardless of time. The whole point of Foundation as a series was that there's no real protagonist in the series; the society as an aggregate works in a certain way as dictated by the rules of psychohistory. The concept wouldn't have translated into a good TV show.

The show that we got is more of a generic space action, which has some interesting parts, but meh for most of it.