Even if fictional stories are not based on real events or people, or take place in real locations -- even if they're not here on earth -- they can still connect to reality. This is because the reader, who IS always a real person, can contemplate the situations described and evaluate for themselves how they feel about them. This then can have a direct bearing on their own very real lives in some other situation.
Many people here who have read my posts know that I frequently mention Shakespeare's plays and characters, drawing inferences from those situations that inform my own morality. (Or perhaps my own morality informs how I understand the stories, but it doesn't matter which way that happens, the end result is to help strengthen my own moral precepts.)
And that, I think, answers the OP's second question, can fictional stories provide wisdom -- yes, of course they can.
And this brings us to stories told in religious works -- for example the Book of Job we're discussing in another thread. Religious people are often surprised at how well non-believers know the stories of the Bible, but they shouldn't be. Anybody who likes to read can enjoy reading a lot of the Bible (not all of it, though...those endless "begats" can cause hardening of the cerebral arteries!).
But we always caution: they are still stories, they are not to be taken as real. But if they are thought about carefully, they can indeed provide wisdom. Just, sometimes, not the wisdom the original author may have been hoping for. That is, we may find the story to be an interesting piece on how the writers thought about their deities, but it may also be a terrible example of merely human moral behaviour.
And learning that can be wise, too.