How to deal with family disappointment

Hi,
I started uni in September just gone. All was fine (ish) for the first two months and then I slowly began to hate it. Things weren't sitting right with me and I keep seeing other healthcare students studying a different course and having a gut feeling that I should have just applied for that course in the first place as thats what I originally set out to do.
I raised my dislike of my course to my dad a few times and he always urged to just keep going with it, and theres plenty of job options once I finish in 3 years etc. But it's got to a point where I'm so unmotivated, I can't engage with the lectures and practicals because I know that I do not want to do the job at the end of it.
I've spoken to the university about course transferring starting next year, or withdrawing and applying somewhere else. I’ve got my ducks in a row about putting a new UCAS application in for the next academic year, I’ve contacted SFE and applied for full time jobs to support myself in the mean time.
The issue is my dad feels so frustrated by the whole situation, and I understand where he’s coming from. I feel frustrated at myself for not having the confidence to apply for the right course in the first place.
He’s been very generously paying for my accommodation, and I have been appreciative of that. But now that I am withdrawing/suspending I need to find a new tenant and have started the process to do so.
He’s frustrated at the waste of money, and he says he’s spent all the money to get nothing out of it. I share the same feelings but the thought of it makes me cry. I feel like such a disappointment for not just making it work but I’m desperately trying to rectify it by getting onto the right course next year.
I apologise that this has been a huge post about my sob story but I’m not sure where else to put it. Has anyone else been through the same thing? How did you deal with family being disappointed and angry at the money side of things?
Thanks x