Sure, there are people out there who don't care about being successful.
But it depends on what you define as success. Do you mean somebody who is famous? Or someone who is just good at what they do?
Look at the way Steve Jobs is treated. He's treated as the highest level of genius, despite the fact that he never really invented anything; he just took other people's ideas and ran with them. Apple is really stolen from Bill Gates, who is the one who invented the personal PC...they were best friends, and they split and started separate companies, from what I remember.
Then look at Tim Berners-Lee. Who is that, you ask? He's the guy who invented the world wide web, or internet. He's the one who's responsible for us even having this forum online to talk on. He never gets mentioned, despite the fact that he not only invented the code that defines and transmits web pages, but he invented what was the very first web browser. Everything that is current now is built on what he created back in the early 90's, and what he presented to the government. And for your information, he never knew it would be such a big deal; the internet was created for the government to share information with each other, and another guy took it and presented it to the public, which gobbled it up (as any new technology will be.)
Do you want to be a rich guy like Steve Jobs, the public face of a company? Or do you want to be a poorer guy like Berners-Lee, who is an actual inventor, but was never the face of his product?