I've been asked to do a retrospective since I was about 28 and I always thought that was a bit odd. It's great to look forward as an artist because in the future the possibilities are infinite you look back and it's all fixed so it's a scary thing.
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.