I’m sure I will get flamed for saying this, but don’t think you will get a lot of helpful advice by asking on a generalist board aimed at the over 50s. There is a lot of prejudice against higher education for its own sake on here, and also a lot of people who had good careers in the days before having a degree was anything like the norm. This means that (some of) those with degrees can feel that their scarcity should be preserved, and (some of) those without can see them as some sort of self-indulgence. It is difficult for those of us who started working in very different times to advise people about today’s employment market. At best we are looking back decades, or seeing our children or even grandchildren’s experiences at second or third hand. You really need to speak to people who are in your own field with much more recent experience than most of us have on here.
One thing I would remember is that if you drop out now you will still owe fees for the two years you have taken, and you will have nothing to show for them. You may be able to get a Certificate of Higher Education for completing the first year, and a Diploma if you see the second year out. It is worth checking that with your course leader or student welfare service, so you don’t leave empty handed.
I worked in HE for many years, and saw countless students flounder a bit in second year. The first flush of being at university has faded, and the work is harder than in first year. Also, the end seems a long way from sight. It’s quite usual to feel as you do, but also quite usual to feel very differently when you get to the final year and are concentrating on the areas you like best, writing a dissertation on a topic you have chosen etc.
Is there someone you can talk to about the areas you see as pointless? Again, your course leader is a good place to start, or a personal tutor? The chances are that it’s more a case of you not yet realising why certain things have been included on your course. They may be professional body requirements, for instance- difficult to say without knowing more about the subject area.
Is there a course you could transfer onto? It’s not impossible, even half way through, depending on the learning outcomes you have achieved to date. If they can be mapped onto another course it may be possible to do the final year elsewhere (or on a different course at the same university).
Are exams or assessments looming? Again, at this time of year it is normal to feel stress, and one of the things that employers like about hiring graduates is that they have proved that they can get through stressful times - it is one if the ‘graduate skills’ that stand outside of the subject matter.
On the whole, I think that dropping out at this stage is rarely a great idea. A year out and a second year resit will be expensive, and you would be starting again with a lot more debt than if you transfer onto the third year of another course. On the other hand, if you can afford it, then taking a year to clear your mind and maybe earning money to pay off some of the debt might be a good idea (but finish the second year if at all possible!).
Good luck with whatever you decide, but try not to make decisions based on fear of failure, or on not fully understanding the relevance of everything you are studying. Ask as many questions as possible of the people whose job it is to know the answers, so you are fully informed before you do anything rash.