I don’t think you are unmotivated. And I don’t think you shouldn’t have gotten the job. I do think it would have been better if you’d been straight with your folks but that’s water under the bridge at this point. I think you weren’t ready for more school and didn’t know how to say so or felt that you didn’t really have a choice.
I’m sorry that high school students aren’t given more support for taking a year or two off between high school and college. Your story is all too common. Colleges are now focusing on “retention” because they lose so many students after the first year. Better to take a couple of years to determine what you are going to school for rather than just going to school. You will get far more for your time and your money if you have a direction.
There is no shame in taking a year or so to work, to travel, or to participate in a gap year program. You can find a list of alternatives in this article.
You’re right. The retail store was a good break and a positive learning experience. I don’t think you should quit a paying job for the summer. I do think you need to be more directed in what to do next. Learn from your mistakes and make time over the next few months to explore your options and to make a clear decision about your next year.
Don’t go to school only because you don’t know what else to do or because of what other people think. Instead, figure out how to try out various professions that interest you or immerse yourself in a different culture. Take a class or two, either for credit or not. (Did you know there are free online classes available in just about anything? See MIT’s online offerings. Or look into Coursera.) More experiences and more exploration will make it clear what kind of school you should go to and what you might want to pursue as a major.
You do owe your parents a bigtime apology. I suspect they are more upset that you lied to them than that you weren’t ready for college. Make amends as best you can and engage them in a discussion about a reasonable plan for the next year or two.
I wish you well.