What are your career goals? What does your ideal job look like? How many different professionals have you shadowed and which shadowing experience did you enjoy the most? What are you really good at? What subjects at school really interested you? Are there any activities that you feel like you can get "lost in" - something you enjoy doing so much that you lose track of time and even forget to eat? What are you passionate about? Do you have any role models, and if so, what kind of work do your role models do?
Pharmacy school can be a stressful experience, as well as it's a huge investment of time and money. You will likely have to either do post-graduate training (residency or fellowship) and/or move around the country in order to find full-time work. In my humble opinion, traditional pharmacy work isn't the most stimulating or fulfilling work, and there will be days where you might feel like a glorified DEA minion or a diabetes enabler. Pharmacists don't have a lot of autonomy in most practice settings, and most of our "interventions" are fixing other prescribers' sloppy work. Being a pharmacist has its moments where you do feel like you've made a difference, and no doubt you do get compensated well for your work. Nonetheless, burnout is common in retail - it can be a difficult work environment to thrive in. There is some flexibility to what kind of work you can do as a PharmD outside of retail (e.g. hospital, long term care, managed care, industry, academia, government, consulting, informatics/health IT), but those jobs are harder to come by and are usually not entry level (some hospital staffing jobs being the main exception). You will likely have to go above and beyond just having a PharmD (postgraduate training, another advanced degree, exceptional networking skills, etc.) in order to get a job outside of traditional pharmacy (some of it is also just dumb luck and knowing the right people at the right place at the right time).
Should you go to pharmacy school? It all comes down to what your priorities are and what you are willing to risk to accomplish your career goals. If you think you will do well academically in pharmacy school, and are willing to move to a town where you have no friends or family in order to work a retail pharmacy or hospital pharmacy job, then I would say pharmacy school is still worthwhile. If you are not sure, I would highly encourage you shadow many different health care professionals or even professionals outside of healthcare. Pharmacy school is 4 years of your life and $100k+ you will never get back - are you willing to risk all that in order to potentially end up working in retail in a less-than-ideal geographic location? Do you want to be a pharmacist badly enough to take that kind of risk?