For light aircraft pilots...

you need some ability to do math, but it's not very hard especially if you're flying tourists around in visual conditions.

In the US you do need any formal science education, although you will need to understand some basic physics and engineering principles to earn a commercial certificate. Everything you need to know will be taught during pilot training, one way or another. No technical knowledge of chemistry is involved at all.

Outside the US, some countries require extensive and detailed formal training in a wide variety of technical subjects. But they typically don't require a college degree.

But the best large plane/airline jobs are very competitive, and would probably not be available to someone who struggles with basic science in school.