It works for d&d style game-worlds, but there's plenty of others where the afterlife isn't as concretely good/bad/divine, and people get resurrected in them all the time.
From a societal standpoint, it's heartbreaking for the ones that aren't ressed, yet didn't necessarily have a better or worse place to go, due to their deeds in life. Or if there is, heaven sometimes has a hero/lvl cap, where you have to be really damn good to not just become a part of some wibbly wobbly "nice" thingamajig. So having another crack at not only becoming "good soul slushie" would be worthwhile.
Heroes get constellations. Peasants get, ummmm, nice stuff?
And if there's just nothing after, or nothing worthwhile not living for, wouldn't you want to remain living? Especially if the only chance of paradise you have, is in the place you live, with death simply being a finality of existence unless you're resurrected.
Worthwhile another crack at it if you could be ressed, imo. Constellations, floating to the top of the slushie, or a "heaven on earth" for the effort. Especially when some are being ressed, and some not, you'd revolve your life around being one of the "haves", rather than the "dead".
Even from the D&D perspective (a horribly broken and stupid gameworld, but simply well known), a low level druid can feed plenty of people with goodberries. You literally shouldn't be able to have a story of starvation in the game world. Yet the peasants still toil in their fields, and sometimes starve due to famines, instead of having a quality of life unsurpassed. And they work, live and die, all while the uncaring deities, magicians and kings look on and ponder whether resurrection is "right for them". All things considered, a horribly dystopian world, and any afterlife world look better to a peasant, knowing what they could come back to. Or even a cessation of existence as a reasonable blessing for their toils.