I'm sure Picard Season 3 will be that good... BUT...
If it really turns out to be the case: The stragglers won't actually care about how good it is. William Shakespear could come back from the dead, Gene Roddenberry could come back from the dead, The Great Bard & The Great Bird could write something spectacular and it could be directed by an also-resurrected Stanley Kubrick, and with that kind of All-Star Talent, they'd still find a way to complain for exactly four reasons:
1. It was made in the 2020s, not the 1990s.
2. It doesn't line up 100.0% with what they want.
3. Canon. Always canon. The more minute, the more important.
4. They'll follow the herd. If the Fandom Menace (Doomcock, Midnight's Edge, MechaRandom42, etc. ) says it's bad, and everyone else in those circles says it's bad, they'll follow the herd, and echo the echo chamber. "It sucks!" "Have you seen it?" "No! And I don't need to!"
If it's good, it doesn't matter. If it's legitimately bad (as in for real reasons, and not what I listed above), it doesn't matter.
I don't think 100% will be won over. If I like it, I'll be happy if 67% are won over. Fandom is like politics. It's not about the unanimous, it's about the majority (half) and the super-majority (two-thirds). Once you have the super-majority, you're golden.