What is the secret sauce in Little Red Riding Hood?
Where's the trick?
Basically, the Wolf learns a secret from Little Red Riding Hood, then runs off and tries to exploit it. Why? Because LRRH did not take her mother's instructions seriously; about not talking to strangers. And she learns her lesson, with the help of a woodsman.
So copy that. From any story, pick a story you have read, and analyze it. What exactly was it trying to teach us?
The first Star Wars movie we see, with the rise of Luke Skywalker, is about faith. Luke is a child with no faith. At the end of the movie, when all is about to be lost, Luke finds his faith, trusts The Force, explodes the Death Star and wins the day. (Just the battle, not the war -- Darth Vader goes spinning off into space.)
The whole movie is about trusting your Faith in the magic of the Force, if you don't believe in it, you will fail. When Luke says "I'll try," Yoda replies, "Do or do not, there is no 'try'."
Then Luke tries, and fails. (He had to, the finale is when he finally succeeds.) That is the secret of the story.
So you can take that, and follow the same beats (critical moments) as Star Wars, but change the setting. Your story is about Faith. But not exactly in Magic. Say your protagonist is starting a business, or getting a college degree, or is anybody else with a problem, thrust into a new situation by disaster or crime, forced to adulthood immediately, etc. Like Luke.
You can do this with short stories like fairy tales as well, of course, or even short stories like Stephen King puts in collections.
Rather than fairy tales, I would take any current commercial success, figure out the secret sauce of the story, and then try to put new meat on the bones.
This is good practice, and will help you learn to read great stories analytically. Many will advise you to read good authors, but they don't tell you how to read.
Specifically, you want to read without getting immersed in the story and your imagination. If you get immersed, you are not looking at technique, how the author describes a scene succinctly, why the author chooses some words or sentence structures, the ratio of dialogue to description and how they are interspersed. And the larger elements, like what was left out, how they "break" or transition from one scene to another, how they end scenes. And what is the change wrought by a scene? Does it start on a down beat, or an up beat? Does it end on a down beat, or an up beat? What new information was revealed? What questions were resolved? Which characters were most affected by this scene; whose courses were changed?
This is the kind of stuff you need to know to pull the skeleton out of the story.
And reading as an analyst, instead of reading for entertainment, is also how you can learn how modern best-selling writers format their dialogue, pack it with information and emotion, intersperse it with action and narrative and description, and so on.