Not really but sorta? I don't know that I'd call it contradiction so much as working with limited information.
When we are alive, we want to be acknowledged, at the very least. We might think about making arrangements for our stuff after we are gone, or trying to reconnect with someone to say goodbye before it's too late, etc. Knowing that we will die tends to inform some of our behavior when we're alive.
Now, we die, and that's that. Maybe we experience something after, maybe we don't. We don't know. There's lots of good guesses out there, some more coherent than others, but even if we lean toward oblivion, we cannot conceive of it, of non-existence.
So, we don't focus on that part. It's not a useful thing to examine and results in crisis for some. Instead, we focus on life, because that is knowable to a degree. Funerals are as much for the living as they are for the dead who were previously alive. We die knowing, or hoping maybe, that we will get acknowledgement that yes, we existed, after we pass, even if we do not directly experience it.