If you expect to be significant or world-changing, the odds are slim
I would disagree. The odds can be quite great that your life will be significant and even world changing to someone or even some people. What is unlikely is that you will be "famous". I fully expect that my life will be significant to some friends and family and certainly to my daughter. Hopefully, my life can have a positive impact on people beyond that sphere. But if I were to judge my worth based on "fame", chances are I'll be disappointed.
I have nothing to base what I'm about to say on... but it's my guess that if you were either: 1. highly influential (positively) on a small set of peoples lives that you interacted with intimately or were 2. highly influential in general but never intimately engaged with those you influenced you would be happier as the former.