Caring about future generations on one hand, and making sure that one's own children will be very well off financially (as opposed to merely debt-free) on the other hand, are very different things. I don't think that effectively giving shares to a CEO's children incentivizes that CEO to make decisions that benefit future generations as a whole. It might, however, drive her/him towards a long-term thinking.
If she/he has children, that is.
You don't need CEO money to escape the bonds of debt. I went to prep school, where most of the parents were stock brokers, lawyers, doctors, or sub-C-level executives. Annual salaries in the hundreds of thousands, but not millions. Between merit scholarships (which are easier to get when you're well-off) and family money, every student there that I still talk to graduated college with little or no debt whatsoever.
Maybe the best thing to do is to abandon performance-based compensation entirely, because it can't be done over long timescales and over short ones it is an abomination.
Note that plenty of founder CEOs are happy to accept near-infinite delays in payment. 90% of Jeff Bezos's wealth is still in Amazon stock despite being there 20 years. And Amazon has been kicking the asses of its competitors for decades precisely because it has been willing to make very long-term investments.
With Bezos, we are talking about amounts of money so large that I (and I assume you) can't truly conceive of them. If 90% of his net worth is Amazon, Jeff Bezos has ~$3 billion dollars invested in companies other than his own. He's plenty diversified and if that 3 billion is properly managed, he'll never want for anything, ever. Even if Amazon stock falls to 1/10th of its value, Bezos's life won't appreciably change, he'll just have slightly less leeway when building his multi-million-dollar cave clocks.
I'll note that the companies of the post-war economic boom (1946-1980) did well enough even though median CEO compensation (cash, stock, and options) was around $1m annually in real terms. So it's reasonable to think that we'll still be able to attract decent talent for the merely 2x that CEOs are getting in cash. The long-term stock would be an incentive for long-term behavior.
I wonder what situations this would apply well to? It doesn't greatly bother me that CEOs of oil companies are profit-driven, but the concept of rewarding someone's work by enriching the people that they love, rather than just creating short-term incentives, would fit especially well with nonprofits and NGOs, which oftentimes seem like their primary mission is to justify their continued existence.