This is a great mini story that helps to understand the meaning of this tarot card, one of the most beautiful ones:
On the bleak landscape where the Tower stood, the Fool sits, empty, despairing. He hoped to find himself on this spiritual journey, but now he feels he's lost everything, even himself. Sitting on the cold stones, he gazes up at the night sky wondering what's left. And that is when he notices, nearby, a beautiful girl with two water urns. As he watches, she kneels by a pool of water illuminated with reflected starlight. She empties the urns, one into the pool, one onto the thirsty ground.
"What are you doing," he asks her. She looks up at him, her eyes twinkling like stars. "I am refilling this pool, so that those who are thirsty may drink, and I am also watering the earth so that, come spring, the seeds will grow," she tells him. And then she adds, "Come. Drink." The Fool comes to kneel with her by the pool and drink. The water tastes wonderful, like liquid starlight. "I can see you are sad," the girl continues, "and I know why. But you must remember that you have not lost all. Knowledge, possibilities, and hope, you still have all of these. Like stars, they can lead you to a new future." Even as she says this, she began to fade away, like dew, vanishing. All that remains is a gleam that was at the center of her forehead. This rises up and up, until it settles in the night sky as a shining star. "Follow your star," the woman's voice seems to sing from that light, "and have hope." The Fool takes in a breath and rises. It is a dark night, a desolate land. But for the first time, he has a guiding light to show him the way. Distant as it is, it heals his heart, and restores his faith.
-- (from The Aeclectic Tarot)
There is also a very suggestive passage in Tolkien's Lord of The Rings that clearly evokes the significance of The Star:
There, peeping above the cloud wrack above a dark tor high up in the mountains, Sam saw a white star twinkle for a while. The beauty of it smote his heart, as he looked up out of the forsaken land, and hope returned to him. For like a shat, clear and cold, the thought pierced him that in the end the shadow was only a small and passing thing: there was light and high beauty for ever beyond its reach.