Ummmm I think you'll find it is a science?? The degree that I'm about to start is literally as scientific as my biology A level was... plus it's definitely not a bad degree, as long as you actually go to a decent uni you can use it to go into pretty much any job sector with some further training.
(Also: just because treatment has not worked for you doesn't mean it's rubbish
CBT for example is completely scientifically backed and works for most people...)
It depends which degree you do! If you go for an accredited one (that enables you to go on to further qualifications and become an actual psychologist) then they will likely have a decent amount of science in them. Equally some degrees are less scientific than others. Maybe have a look at some unis you like and read the course modules - that should hopefully give you an idea. That's what I did anyway, as I knew I wanted a more scientific degree - so different goal but same method haha!
(P.S. if you're just worried about your aptitude, don't let that put you off - most degrees do have a significant practical element, but you'll be fine! Also, not all courses involve dissection etc - so practicals might not be as gross as you think
Once again, I can't speak from experience as I haven't done a psychology degree yet, but that's what I've gathered from open days etc!)