Fairy: enchantment, magic +tale: story, tale, the action of telling, = telling a magic story
A made up story, such as santa claus, the tooth fairy, religion, etc.
Some fairy tales are just for kids, like the tooth fairy and santa claus.

Other fairy tales are also for adults, like religion.