I can understand why some people don't like Picard, as it deviates quite a bit from the Star Trek we all grew up on.
For my part, I love the path they're on with Picard who's always been fair and noble in the past, but in his old age is showing sensivity and tolerance that wasn't acceptable for a star ship captain. I also really like the new characters who are all very flawed and very interesting.
Picard himself has always been my favorite TNG character and I don't really have a problem with his personality and its changes from before. I do find the show is a bit hard to get into (for me) as at least up to the episode I'm at, it's struggling a bit finding its identity; is it action, character or political drama? I find it's trying to do a lot but not hitting the mark.
I don't dislike the show at all. I'm just not into it like I was with TNG and DS9. Voyager was ok at times whereas Enterprise I actually disliked for the most part. I get Star Trek now (Picard and Discovery) aren't as sanitized as before and I'm ok with this.
However, I am still intrigued by Picard's arc and am looking forward to the finale which for me is a couple episodes to go.