Why are some people good at algebra and bad at geometry and vice versa?
In short, algebra and geometry are different type of cognitive abilities. Geometry is more spatial and algebra more verbal-logic.

Kestenbaum, C., Williams, T. D., Handbook of Clinical Assessment of Children and Adolescents, NYU Press, 1988.