So far as I can tell, the idea behind extending copyright two generations after the author's death was so that they could leave the rights to their children and grandchildren, and this would keep old or terminally ill authors motivated.

No, it was extended because Disney and the like lobbied for it to be done.