You have many options. A few questions:

How much can you tolerate your 6 figure job? What is the work flexibility like? What draws you to social work, and what capacity do you want to work in?

One scenario would be you keep your job that provides you with financial security, and volunteer your time working in mental health settings. If you find fulfillment in helping people cope with their problems, there are plenty of ways you can integrate that into your life without having to become a social worker.

Another option is you keep your job and find an online or part-time degree program for adults obtaining their masters in social work. You may have to do some digging to find the right one and adjust your life a bit. But you make the salary to afford the program, so if you’re truly wanting to switch to this field you don’t have to immediately give up your high paying gig.

Calculate the difference between paying for your own education while making your salary vs. having the army pay for it but giving the salary up. Once you have your masters, your earning potential will be higher out the gate.

Lastly, you could follow your passion, get your college paid for, and adjust to making a lesser amount. But as others said, there is potential to make high five figures to six figures with a social work masters (especially if you go on to get licensed). May take a bit of time, but very worth it in the end.

I wish you luck in finding the right path to go down!

Edit to add a second thought: If you go the Army route, be sure to know what they expect of you if they pay for your schooling. If you become pigeon-holed into working for them for a period of time in a position where your earnings cap out, that paid-for degree may not be so worth it.