Yes and No.
A lot of people will have fond memories in 40 years of the Adventure Paths they played as a teen. However, it won't be the same as the people playing now look back on the Modules from our youth. That is absolutely true. Many that played Demoneb in the year it is released will also have fond memories of current Adventure Paths as well.
However, it was a different world in the 1980s. There was no internet. Video games were on the Atari 2600. Most of us played theater of the mind D&D because we had no miniatures (and certainly no VTTs). Our lives were different, and the role of D&D was a different element of those lives than it is now.
When we played the Demonweb Pits, we didn't have piles of Google available information. We were exploring D&D for the first time as new core material was being introduced. It was a disorganized and messy adventure into rulebooks and source material that had a lot of rough edges to cut ourselves upon.
If you're a Batman fan, and you've been reading Batman since 1939, you're a very different fan than someone that started reading in the 1960s, which is different than a fan that started in the 1980s, and is different than a fan that started reading/watching in the 2000s. All might love Batman, but all have a very different idea of what Batman is.
The same is true of D&D players. Those that started before AD&D, those that started in BECMI, those that started in AD&D, those that started in 2E, 3E, Pathfinder, 4E, 5E ... all see the game very differently. And even within our generations there are a lot of different views, especially amongst the grognards.
While new players can treasure the adventure paths as much as we treasure Demonweb pits, they won't be having our experience. It just isn't possible to relive it when so much has changed.