The primary characters had a permanently grafted on idiot ball and made many tragic mistakes in order to keep the story moving. A character from the books who considered violence to be stupid became an action hero who rejected non-violent solutions. It was not good. Taken as its own thing, it's ok, tolerable to watch if you don't have anything better to do with your time.
Yes. My biggest irritation with the show is that literally the entire point of the books, and the reason to read them at all, is the central, intriguing idea of psychohistory and the Seldon plan. These ideas are front and center in the books and literally inform every scene but in the show they are almost an afterthought. The result is that the show feels nothing like the books, at all. Frustrating. Someone will have to remake this show again and hopefully do better at capturing the ideas and feeling of the books.