Edit: this was meant as an honest query, so thanks for the downvote. I love how just shooting my point down with no thought or counterpoint gets upvoted, but asking a question in earnest gets downvoted.
As I’ve had nothing but “no you’re wrong”, I can only assume you don’t have a counter argument, and are just being contrary.
You didn't put forward any compelling arguments for your point of view so I didn't bother to refute them.
It is a big question, but being remembered doesn't even register. Could not care the slightest. Now there are things that I do care about and they sort of implies that I will be remembered (by friends and family) if I get my way (wouldn't be a good friend if that wasn't the case).
But that is not why I do anything, and most certainly is not what motivates me.
I have no interest in being famous.
Sometimes I create things; If people enjoy what I make I'm glad to have slightly improved their life. If not then I hope my existing didn't make it much worse.
I imagine that soon after I am dead, no one will remember my name. This brings me peace.