I'm sure you've heard of the great things you can do with a PharmD. I think the profession has been picking up in popularity and will earn a higher level of respect (and pay) in the near future.
Yes, it involves a lot of studying and it does help if you're a science-oriented person, but I believe anyone who works hard enough can make it. I myself am not extremely confident in the sciences, but my determination to take part in the career will help me get there. And for the record...I've heard that there isn't as much chemistry in pharm school as many people would lead you to believe.
Volunteer or work at a pharmacy to see if you like it. Ask some pharmacists about their job and see what it's all about.