I hear you, the outpatient hospital pharmacy I volunteer at is a scary place. The manager is stupid and overworks her employees, I could go on, but I won't. For I while I was re-thinking applying too. But then I realized I was being taught something:
I believe I was put in that un-attractive retail setting so I would realize that retail pharmacy is NOT for me, kind of like a sign if you will. I have probably not received a real world picture of retail pharmacy, but volunteering there has helped me decide where I want to take my career and has given me some direction.
The cool thing about getting a PharmD is that you can shape your career to fit your personality--you don't have to work retail! You can teach, do research, specialize and work clinically, work for the government studying drug outcomes and compliance, etc. I sometimes get frusterated b/c when I tell people I am applying to pharmacy school they look at me like I am crazy b/c I want to sit behind a counter, count pills and fight with insurance all day. I have to explain to them that that is not what I want to do, and that the PharmD can be a broad degree, if you let it.
I think the key is looking for the jobs/opportunities that let you use your skills, interest and passion. The opportunities are out there, but you have to explore and look for them, and it might require a little extra work, like more schooling or a residency. I encourage you to look at the diverse jobs available to those who hold a PharmD. And then, if you still don't like those options, consider a different degree.
Best of luck to you.