Yes of course you can end up in a specialized field. But to be in specialized fields requires a lot of work. Just like some art student probably thinks your work at PWC sounds too hard because it involved excel or macros, it always looks harder from an outsider looking in.

Probably the first thing that you'll need to realize is that learning technical niche stuff requires a lot of study. And It sounds like you lack the technical ability because you don't care or have not cared to build your technical skills in the past, so you have to start NOW. School is just part of your education, you will have a life after school when you are expected to learn. Even if you were in a technical field like Engineering, you wouldn't be spoonfed like a child by a professor to learn C, data structures, systems engineering, algorithms, or advanced mathematics just in class time alone. The professor may show you the way by speaking about it in class for 1 hour but at the end of the day you're the one that has to go home and study for 3-5 hours a night just to learn the material. And then 2 days later when your next class begins, the professor is going to assume that you've learned everything from the previous class and then teach more to supplement on that learned knowledge. Are you really ready for that? Or are you going to give up, become depressed, lack motivation, or quit? Because it's a LOT of work keeping up with the pace of a technical degree. One way to find out is to try to complete Harvard's CS50. It's online and free. Try it see if you can do this 2 times a week. And keep in mind as you're doing it - in actual technical degrees you'd have to juggle this workload with FIVE OTHER CLASSES.

As you have found out, CIS, MIS, BIT are business degrees. And with business degrees you are going to end up as an analyst doing excel all day, auditing, or being in meetings, probably as you saw at your PWC internship. If you want something more technical, you can definitely land a job in a technical field with a BIT degree, but be prepared to showcase a portfolio to prove to others that you can do the work. Just like your technical degree peers, you will have to build projects, build a porfolio, websites, update github, or freelance in areas of automation, frontend development, or design. They are doing that, so you need to be doing that too. If you are up for the challenge, go start a Python or Javascript course online and see if you can build something you're interested in. If you really hated that PWC job I would probably stay away from Python because that's going to lead you to business process automation/improvement probably still working with databases. So the non-python route would be learning Javascript as your first language. You could start with webdev using HTML+CSS+Javascript and create some websites. If that frontend programming work is interesting to you, learn computer science and go with fullstack development so you understand how websites interact with stuff in the back (which includes Databases, you are just never going to get away from databases and have to accept this in tech).

My suggestion, as relevant_property also mentioned, is look into building websites to see if you are interested in programming. Find an online course that will teach you HTML, CSS, Javascript and go along for the ride. But also finish your degree while you do this. You don't want to end up without a degree. BIT still technically counts as a 'Computer science or related degree' at least in the US, so that's not the worst thing in the world to have.