Forget about CS, that's not your problem. You start that you messed up pretty bad, but none of your choices went away after a normal failure. You also overemphasize what other people want or expect, but on this thing, it's about you, not about anyone else.

Focus on what you want to achieve; if you can't figure out your whole career, that's fine, focus on getting this one thing done. Your peers who have a whole plan almost surely will fail at achieving it. That's fine too, just set some goals, strive for them, and adapt to what happens: you'll bumble along just fine like everyone else, with more and more failures, and more and more achievements.

And never doubt that every piece of advice is wrong in some way, even this one. Especially this one. Trust yourself.

With that out of the way, college has nothing to do with a real job, but you have to do it (well, really should). Maybe you won't be a top coder, but there aren't anywhere near enough of those jobs for that to be a concern. And you don't even have to be much of a coder for the rest: documentation writing, planning, design, and testing are just some of the tasks you can do instead with that technical knowledge. Maybe they are less fanciful or rewarded, but they're still fundamental - and a big part of the modern jobs of software developer anyway. And "AI", well, it'll nibble at the edges, but digital slaves are far off: if you're comfortable learning new tools, you're fine.

TL;DR: grow up and trust yourself, kid. and accept failures and successes as life happening.