I see your struggling and I know your scared but we'll do this together, if you let us. You'll get loads of good advice and support here. Let me add mine.
I went to college and also had a lousy advisor; shockingly so. I didn't know enough to know I probably could have complained. The program I wanted to study seemed to have one focus which wasn't my primary interest. I floundered and dropped out. I worked and also felt a failure because I hadn't finished school. This was all pre-internet.
Now, though, you can do a lot of investigating of career fields, schools, specific programs of study, just by looking around online. You can also get books at the public library that will give you information about careers: the education required, whether it is a growing field, salary ranges, etc. You can take aptitude tests, and you can sort of 'test drive' various fields by volunteering. Many company and organization websites list volunteer opportunities, if they have them.
Let's say you want to be helpful. That might seem broad but not everyone wants to be helpful, so you are ahead of the game knowing
you do. Next you would think about
how: Do you want to be a brain surgeon, school crossing guard, nurse's aide, activities director for a cruise ship, school teacher?
Maybe you are good with your hands: Manicurist, mechanic, plumber, brain surgeon.
Maybe you like physical activity: dancer, tennis instructor, construction worker, installation specialist, day care worker.
I think if you can list the things that interest you; what your natural gifts are (friends and family can help point these out), and then do a little exploring on the internet and by talking to people who like their work, you will get a clearer picture of your direction.
I would tell you, too, that many years after my initial floundering, I went back to school (a different school, with caring advisors and teachers), graduated and have worked in my field for 20 years. As I enter the last quarter of my working life, I am convinced that
all honest work has value and the person you need to satisfy when it comes to choosing educational and working paths is
you. You can succeed; you already have by being employed; decide your other goals and go for them. You're worth the effort.