If you're willing to spend $150,000+ pre-interest on student loans, there's probably a PsyD program out there that would be happy to cash your checks.
There are probably 3 pathways for clinical work;
1. Psychology tech or bachelor's level counselor type clinical positions (e.g., addictions) that come with limited upward mobility and job tasks due to a lack of license but likely easily obtainable if there are local facilities and you can pass a background check and piss test.
2. Complete a licensure-eligible master's level program. Sucks that you already did the SNHU MS but you'd likely be a strong candidate with your previous grad level success, volunteer experiences, statement of purpose and pre-reqs. I would recommend looking into the
MSW program at your local state university, rather than LPC, LMHC, or LMFT programs, and you'd qualify for a wide range of psychotherapy or MH case management job.
3. Gain research experience (volunteering or paid RA), learn the ropes, and get attached to publications with that lab and boost your CV to become competitive for a funded PhD program. However, there is zero need to get a PhD or PsyD to work in mental health so make sure you have career goals that
actually require a PhD/PsyD before embarking due to the necessary prep, time commitment, and financial sacrifices (even if you get into a fully funded program) required.
Good luck!