Yeah he is mostly on the money. I can accept (and actually expect!) that the character Picard has changed over time, but yeah he is basically unrecognisable.
I don't hate Discovery completely, it has had some great elements, but on the whole it's clearly a jumbled mess, and Picard just repeats a lot of the same mistakes and doubles down on them.
There is a contingent of idiots in the fanbase that object to Star Trek "going woke", which is clearly just people who didn't understand any Trek over the years, and that's not why modern trek is a shadow of it's former self. That video does dip a little in that direction, and I wanna be clear that Trek has always had progressive ideals and made consistent, if sometimes clumsy, attempts to advance diversity on TV, and put thought into representation. That's not the problem with Picard or Discovery.
RE: The Picard Ending
ZOMG Spoiler! Click here to view!
I think my biggest problem with the ending is that it doesn't feel like certain characters think synthetic life is inherently less worthwhile than human life, it feels like the writers think that, and didn't even make any effort to justify it within the story. Feels remarkably closed minded, and not reaching out to a higher level synthetic life form out of fear of what will happen would be like wanting to never achieve warp speed for fear of contacting other biological life forms.
Not 100% a disaster, but probably like 90% a disaster. For me, at least.