@GroovyGuru Why not select a new career (not finance), one which aligns with your interests and also has some practice viability. For example, you might be interested in being a counselor or therapist or social worker or teacher or whatever.
If you know for sure that finance is something you hate (and you do), then it would be idiotic to keep pursuing it, trying to fit a square peg into a round hole.
I changed my major half-way through college from Aerospace Engineering because I realized, just like you, that I do not want to work in a cubicle crunching numbers for some defense contractor.
You must follow your passions. But also try to keep an eye on the pragmatics of how you will earn a living. You must develop a clear sense of what your career will be. It is not good enough to just take some major and then have no idea how you will actually earn a paycheck. For example, if you're going to be an English major, then you should also have a practical career plan like: I will be a popular fiction writer and sell books.
Answer this question for yourself: What am I gonna be selling? To make a living, you gotta be selling something. The key is to be selling something you believe in, something you're passionate about.
For example, I sell metaphysical insights that improve people's lives.
What do you sell?
Figure this out NOW! Don't wait! Once you hit the labor force your options will be severely limited and you will be stuck in wage slavery from which it is very difficult to break free. Your plan to escape wage slavery must start NOW. There is no time to waste. Invest some serious time pondering this and laying out a realistic plan.
Don't worry about dropping finance. In a few years you won't even remember it mattered. Changing majors is not a big deal. Graduating with a major you hate IS a big deal. It's a big mistake.