It's definitely got problems as an adaptation of the Foundation series where it turns one of it's biggest themes on it's head by making a few people like Gail super special and having the answer to the crises where the books were more about setting up groups and organizations so that they as a whole had an advantage or edge that would be the answer to the crises he forsaw. I think it's mainly due to them wanting to have the same people across multiple seasons where the books were free to throw away the whole cast each time. Setting up new characters is much more expensive in shows/movies than books where you can just say what someone's 'deal' is and give them internal monologues to setup their internality where shows can't usually get away with that.

I think separated from that there's a good enough show in there.