To say it's beyond hope is not true but it certainly will be very difficult for you to ever get your GPA up to a respectable level.
That said, there are some schools that offer academic forgiveness and/or just look at your pre-requisite GPA. Thus, if you go to a CC and re-take all of the pre-requisites, and perform well, and perform very well on the PCAT (something people seem to leave out of these doom and gloom type posts), you might, MIGHT have a chance to make it. A lot of variables will be at play, but of course the biggest one is you.
Before you failed Calc II three times, were you a straight-A student? Did failing it the first time send you on a downward spiral and cause an overall loss in grades? I mean, even if you get into pharmacy school, if you're just not a good student (and some people are just genuinely, legitimately bad at academics, it isn't for everyone) then you might find yourself washed out of Pharmacy (or worse yet, graduate and not pass NAPLEX).
You need to evaluate your strengths, weaknesses, and goals and match them up. Not everyone can be Le Bron James and toss 3-pointers at a buzzer, not everyone can do space walks, not everyone can be a Pharmacist, not everyone can be a police officer or a soldier. Keep this in mind when you're evaluating yourself... Just because you want to, or fancy the idea of, become/ing a Pharmacist does not mean this is the field for you.
This may sound like a really, really dumb question, but if you've got no interest in Psychology, when you were pushed out of CHemistry, why did you choose it? You should've had Psych courses during your lower division years (at least one, but I took two requisite courses in psych for my lower-div) and been able to discern your lack of desire to do it in the first place.
You're in a tough spot, no doubt about it. Is it insurmountable? No. Will it take severe changes in your lifestyle/habits to accomplish your goal? Yes.