But even Ramessess II is not really "remembered" by more than a tiny handful of people. Most people who recognize the name know nothing about him, and most would never come up with the name unprompted. Most knowledge about him is lost.
We know him in the very abstract, not all much different to how we know the Ozymandias of the poems.
To the extent that being remembered after your death matters at all, then absolutely, yes. To go back to the original point of comparison, many more people know Ramesses II now than have ever heard of Paul Graham, and this is when pg is still alive and probably near the all-time peak of his fame. There's a relatively small, but not that small, number of people who can name some of Ramesses II's monuments or other achievements without looking them up. And there are many millions of people who are vaguely aware that he was one of the GOAT Pharaohs, and that was more or less the core objective of all the monument-building.
I mean, who knows what random selection of events will cause someone to slip through the crevasse of history into the future. Imagine being the fossil that is found and paraded as the missing link between our species and the one that roams the earth 100,000 years from now, and Ramesses II nowhere to be found...
I didn't find a mention of him making a mistake in this article, but I think I read somewhere a while ago that the numbers he wrote on the tablets had some error somewhere.
We know him in the very abstract, not all much different to how we know the Ozymandias of the poems.
Does that level of being remembered matter?