I was well informed of the lack of job prospect for a philosophy major the first time I voiced such interest to my parents back in 6th grade.
I wouldnt pick school based on jobs it can give.
I picked a school based on the job it could give me, instead of the one I wanted, because my parents convinced me that the one I wanted wont give me a job.
Now I do a job which is completely irrelevant to the school I went to, which I could have had even if I didnt go to school, and I missed to get education which actually interested me.
Of course, the school which was supposed to "give me a job" ended up being terribly boring, causing me to fail completely at school and when I finished school with minimal success and lowest possible grades which still let you pass, I didnt have knowledge nor interest to do any of the jobs the school actually "educated" me for.
So if you want to go to school for a certain job, first ask yourself if you will have the knowledge and interest to do that job for the rest of your life.
My answer to both was no, but sadly, I didnt think about it well enough when I started school, and I was terribly misinformed by my own parents about what the school actually teaches. By the time I realized, years already passed and it was impossible for me to switch to other school.
I am not giving you advice. I dont know your situation. But lets just say that some people who dream of specific jobs while students dont get to do those jobs. My entire education was literally completely irrelevant to the job I do.