I was there too, and I thought my life was over too. I can totally relate man. And I have two words for you: correspondence course. seriously. read on.
I graduated 10th in my class (out of 300) from high school, scored a 730 in math on my SATs, headed to college with a 4-year Navy ROTC scholarship. Very first semester there, I failed Calc I. It wasn't that I wasn't smart, just "burnt out" if you want to call it that...just didn't feel like doing anything (study, go to class, etc). Long story short, failed Calc I & II at least 4 or 5 times combined I think. After 2 years in college, I was dropped from Navy ROTC due to poor scholarship. I thought the following semester would be my turning point, since I didn't have ROTC resposibilities to worry about, which I figured would leave me more time for my studies. wrong! That semester was when my college career hit rock bottom. I got a 0.93 GPA that fall semester, and the day before Christmas, I got a letter from the university stating that I was being dropped from full-time degree status. Merry Christmas.
So, that spring semester I spent at home, working as a grocery store clerk/stockboy. That was my wake-up call, realizing that if I didn't do something, I'd end up stuck in a job like this for the rest of my life. I was still able to take classes from the university, so I signed up for Calc I as a correspondence course. Best thing I could have ever done.
See, with the regular calc classes, the course grade was composed of like 80% or so from the 3 exams (2 midterms and the final), and the remaining 20% from a couple quizzes during the semester. 0% of the grade was based on homework, in other words, no homework was ever due. This was what killed me in the regular classes, I just never did any homework, never kept up with where we were in the book. In contrast to this, the couse grade for correspondence course was based like 50-75% on the regular homework assignments that I'd mail in. Well, this worked great for me. Since I knew the homework was weighted so heavily like that, I put a lot of time into it, and got excellent grades for my assignments. A "side result" of the time I spent on my homework was that my exam scores reflected it. Through correspondence courses, I ended up getting an A in Calc I and a B+ in Calc II. I went for summer session classes that summer, and earned re-admittance into the degree program for the fall semester.
I graduated from Penn State 7 years ago now, with a BS in Computer Science. I've been working as a programmer/software-engineer for the past 7 years, and let me tell you, it sure beats stocking shelves or being a cashier at the local supermarket.
Don't give up man. I didn't, and you shouldn't either. Find something to motivate you (the idea that I didn't want to be a stock clerk the rest of my life is what motivated me). Maybe look into correspondence courses (hey, it might work for you, unless you really don't think so). Your life is not over, just like my life was not really over either.
Seriously, I hope my own story helps you a little.
-hudster