[ Higher Education (University +) ] Open Question : Does college prestige REALLY make a difference in the long run?

I was accepted into some pretty good colleges when I graduated from high school, but unfortunately financial reasons prevented me from enrolling at any of them. I'm planning to begin at my local CC in January, but most likely I'll end up transferring to a university that isn't as renowned as the ones I had initially hoped to attend. So, basically, my question is this: Will I have fundamentally failed as a human being if I end up not securing my BA from a prestigious university? Does somebody HAVE to go to a prestigious university in order to make a decent living?