I watched this recently, and honestly, imo it didn't date well. Season 1 is needlessly woo, and intentionally nonsensical-- it isn't half as clever as it thinks it is, though, in my opinion. There are some powerful moments, but they're let down by the moments that feel forced. For example, bursting into song, dancing midgets talking backwards, or randomly showing a family eating silently for minutes. These are artistic choices that scream; 'look how edgy I'm being!' but coupled with the really bad acting of a majority of the cast, are rather transparent and dated. Without getting into spoilers, the 'true' main antagonist of season 1's just appears ridiculous and not scary. That said, the effect this villain has on people is scary, and the show is saved by a few good actors, including Cooper, the lead.
As for Season 2, I know I'm in the minority, but I actually preferred it, because it embraced the silly sides of itself and became even more of a caricature. The new villain feels more real, in that they could be an actual psycho, yet despite that It is absolutely ridiculous from start to finish, but, there is never a dull moment (unlike Season 1, imo) and it fleshes out a lot of side characters. It does feel like a bad soap at times, and people lament the cringy-ness, but I enjoyed it. I know David Lynch laments this season, but he also put himself into the show and gave himself a kind of borderline creepy role, so... I wouldn't take too much stock into what he thinks.
I don't think TP is the greatest show ever. It's decent. It's quirky, and it'll leave you scratching your head. It sort of fails at the two things it wants to be, a supernatural-style whodunnit, and a quirky soap opera, and it never quite excels at either. If you can put all that aside, then you'll probably get a kick of it.
The ending is a mind F, to be sure, and I didn't enjoy it