I’ve never watched Picard myself, but the the main thing I took away from watching the video was that the person who made it loved TNG for being a show that tried to take a realistic look at our problems and present a fun show about a world where we have found solutions for them, while inspiring people all over the world, including the person who made the video, to become scientists and engineers. Meanwhile Picard is a show that is miserable and hopeless and will never inspire anyone to do anything. Also it just wasn’t well written.
That’s just my personal main take away from a single video about a show I haven’t watched, so take that for what it’s worth.
Trust me, I am all too familiar with losing hope in humanity as I get older and more cynical. That doesn’t mean I want to spend my time watching a show about torture and misery and sadness and hopelessness. I want something better out of fiction than I get out of real life. Otherwise, what’s even the point?