I get that you're talking about those haters, not the people with valid reasons to be disappointed with Picard. But I just watched TOS, TNG, Voyager and Enterprise seasons 1-3 simultaneously, for the very first time in some cases. I watched all the season 4s alongside season 4 of Discovery. I know what they're like when directly compared, without any 'franchise fatigue' or concern about how they'll destroy canon, and I can tell you that people had plenty of valid reasons to dislike TNG and Enterprise when they first aired. Those first seasons were terrible then and they're still terrible now, to me anyway. The series improved a lot afterwards, and I think that's what really won people over. Season 3-6 TNG is the 'holy grail of Trek', season 3 of Enterprise is 'serialisation done right'. If Picard is remembered fondly years from now, it'll be because it recovered from this slump.
Personally I like Picard season 2, I think I like it more than most in fact. But I can't defend the storytelling because they've really dropped the ball on it after episode 3, and everyone can see it. We've all been left hoping that there's some kind of payoff at the end that explains what the point of it all was, because it keeps kicking that can down the road while the characters continually deal with complications.