Uncertainty and confusion is normal, especially at this transition stage in life. Don't fight it, just accept it as something you gotta go through, even learn to enjoy the feeling
it means you're truly open to answers instead of thinking you know it all.
In reality, there is no "right" or "wrong" path. There are just options and likelihoods and consequences. All the guilt you feel about matching up to other people's expectations, simply doesn't exist in reality. It's not your problem, it's theirs for putting expectations on you in the first place
However, it also means you have to get real about the consequences of your choices. If you can accept how your life will turn out if you follow your passions and drop out of college (i.e. if you're ok with not having "worldly" success, and being happy with a simple life), then don't be afraid of choosing it, even if nobody else will understand. If you can't accept that, or you feel that you need your parents/friends/significant other's approval (not meaning this in a negative way, just objectively speaking), then there are other options like finishing your degree, getting a job, etc. You have absolute freedom to choose your own path, but each one has its consequences. There's no right or wrong, just ones that make you more or less happy