Outside of that field, his takes are your typical "genius in one thing believes he's a genius in everything". Someone even made a list of his mistakes: https://hopsblog-hop.blogspot.com/2016/01/fact-checking-neil...
One of his tweets that HN will love: "Obama authorized North Korea sanctions over cyber hacking. Solution there, it seems to me, is to create unhackable systems."
I agree that the fundamental thing here is:
> "genius in one thing believes he's a genius in everything"
No disagreement here, and sadly I think this is an unfortunate part of human nature.
Other than that, I'd say the person who wrote that list has a beef with Tyson, there's a mix between honest mistakes and debatable things, a lot of nitpicking (with a dose of cherry-picking), and ultimately this doesn't prove that "most of [Tyson's] takes" are mistaken. I agree that some things he says are dumb (like the cybersecurity tweet you mentioned) but I wouldn't dwell too much on them. "Cosmos", in all of its incarnations, is amazing. Of course, I'm not arguing the script is his, but his delivery and screen presence are solid.
I see Tyson commented on that blog, and some of what he says makes sense (e.g. picking on his colloquial use of "exponential" seems a bit mean spirited, though he could have been more precise; some people misunderstand the spirit of his comments on scifi movies; etc). In general, his replies in that blog to what at some points amounted to personal attacks left me the impression that Tyson knows how to gracefully and politely handle flamebait.
...on some things, because he's only human, and some pretty solid views on other things :)