If you had asked me a few years ago whether people would look more fondly on the Sequels in the future, I would’ve said “no.” But, after seeing the drastic turnaround for the Prequels’ perception, I’d say that anything is possible. It’s probably not going to happen to the same degree as the Prequels, but it will likely happen.
Most casual viewers just watched the ST, enjoyed it in a casual way, then moved on. They’re the silent majority of Star Wars viewers. Then you have the fans who are a little more enthusiastic and invested, so they can go either way but usually lean toward the positive side. Then you have the hardcore fans who feel very strongly one way or the other.