My guess is that most don't consider it now, but that could easily change if you enshrined it in law and horror stories got passed around of Joe Schmoe Author who died young and left a destitute family.
However, the entire question of how copyright incentivizes creation is extremely murky and there seems to be roughly zero hard data on it, so that could be totally wrong.
If a plumber and an author were to die young, the Plumber's family have already benefited in full from the results of work the plumber did before death, because payment in full was made immediately when the work was done. What you are arguing for is that the author's family should not benefit in full from the work the author did in life. Why is that?
Consider the scenario in which a plumber does a job, then dies before he gets paid. Should that invalidate your debt, or should you still pay what you owe to the plumber's estate? It seems obvious that it's the second one.
Do royalties add up to something meaningful for the estate of authors in 1% of the case? 0.1% 0.01%?
And, just as importantly (perhaps more so), do authors take this into account when they are creating?