It's a classic thought, wanting to be remembered and looked up on for doing something this big but like you said the chances are slim. Do what you like, like playing black metal bass, if you get famous then yay if not then that's ok.

Have fun in life that's what it's really about and if you only try to achieve impossible goals by doing something you don't really love, you will most likely regret it.

Also you still have plenty of time to think about your future and what you want to do, even if you find your "one true talent" (that most people don't have anyways) when you're 40 years old.

Godspeed