I personally would want people who I know and love while I am alive to forget me and move on with their lives after my death.
It’s like I would be happier in whatever is in the after life to see the people who I cared about happy with their lives, instead of getting sad whenever they remember me or worse yet, remembering me on yearly basis after I am gone.
I genuinely find it very illogical and selfish for people to want everyone to never forget them long after they are gone, especially due to the pain that come with memories.
That is why I am curious about the reason.
You should read the book Denial Of Death by Ernest Becker.
In the book Becker says that the fear of death is always present in human subconsciousness. Resulting in a drive to transcend death at least in a figurative way.