Personally I kinda liked the first season. It's better if you forget the original Asimov story and just watch it as its own thing because it diverges from it quite a bit.
I found that there were two stories, one with with emporers which was really compelling and another story with the Foundation which was really dull which is why I give it an overall rating of 5/10
I actually get the feeling this started out as a totally different series about an empire of clone rulers existing over millennia, and they struggled to sell it so they reworked it into a hodgepodge adaptation of bits from every major asimoverse book combined and time-shifted into one series.
I get that feeling a lot. Season 1 of Star Trek Picard makes way more sense if you think it started out as some kind of Blade Runner fan fiction that was clumsily smashed into Star Trek.