So...let's go by the numbers:
1. Science isn't your strong point: Look, without broaching the topic of whether you need to be strong in the sciences to be a good dentist, let's consider how important it is to get into dental school. The DAT tests your knowledge in biology, general chemistry, and organic chemistry. It makes up 3/5 of your academic average, which is the primary metric used to gauge someone's performance on the DAT. Not only that, but you'll be taking 9-10 core science courses as pre-reqs. I remember when I took biology my freshman year, I met a ton of students that were pre-med/pre-dent. By the end of the sophmore year, a large percentage of them had realigned their career goals because they realized they couldn't hack the basic sciences. All this is to say - if sciences aren't your strong suit, they probably will be by the time you start dental school.
2. Dentistry doesn't take a genius, and values artistic ability: True, AFAIK, on both points. None of the healthcare fields take a genius to break into, though. I can't speak too much about the artistic side of things, but the closest thing to that on the DAT is the perceptual ability portion, which doesn't count toward your AA, but is still important.
3. Can you get into dental school and thrive?: Nobody here is going to be able to give you a solid answer on this one. We're talking in vague generalities here, because we're anonymous internet human beings. If I knew you personally, I could give you my impression of your likelihood to succeed, but that's all it would be, my impression. Best I can do for you is tell you that it is absolutely possible, given the necessary hard work and dedication. For now, that means getting that GPA as close to 4.0 as possible, and educating yourself about dentistry and whether it's the right career for you. I would recommend doing some shadowing, and finding yourself a volunteer project near and dear to your heart.