I certainly don't think you need to be famous to want to leave a legacy but when you are famous it's even more likely that your child will get the wrong perspective on your life if you die prematurely.
There are plenty of problems in the world and doubtless climate change - or whatever the currently voguish phrase for it all is - certainly is one of them. But it's low on my list.