This is a good point. I was discussing this with article with my brother, and he argued that the reason magic is more appealing than science is that magic is more like an art than a science. Since more people are good at art than good at science, it's easier to identify with a supermage than with a superscientist.