It seems that the underlying question in the original post, assuming that you classify your CG work as art (maybe some people don’t?), is “What is the role of art in society?”
I see art as playing a very important role. It serves to make other people more aware of their world - it raises questions and points out the not so obvious, or maybe the obvious but understated. It brings us closer together with other people in a shared experience. Emotions are such a powerful aspect of our lives that it’s foolish to ignore them or stick them on the backburner, and art can bring out some mighty strong emotions. Art calls for change, and, even if no one listens, stubbornly persists. It brings hope, happiness, anger, awe, and beauty… I don’t think we could really live without it.
That’s the ideal, I guess. I’m not trying to suggest that becoming an artist means you can change the world and all that jazz, because realistically very few people in history ever accomplish that. But I think trying to reach people, to stretch out and touch them somehow, is an extremely worthwhile goal.
Every occupation has its role… science is certainly important, but understand that it is limited like everything else. Science cannot solve every problem… it can help five-year old children with terminal illnesses, but so can a movie like Monster’s Inc or a video game. It is easy to see entertainment as frivolous, but where would we be without it? We are not machines that can survive on just basic biological sustenance… our emotions need nourishment as well, from the time we’re born until the time we die.
I see art as providing some of that nourishment - at least, some kinds of art. In the end it is your decision as an artist to decide what kind of art you wish to make… substantive and stimulating or vapid and meaningless… and, of course, it is also up to you to define those terms as you see fit. But lest you get too creative in your rationalization, the closest thing I see to a standard is simply “common human experience” - and that is why I agree with Lunatique that storytelling is so fulfilling.