I'm just learning Maya myself, but I am a artist and a sculptor and I do believe drawing aiblity helps you sculpt. And vice versa. I'm hoping this helps me model in Maya.

But is seems there are other aspects of modeling or working with this medium that don't require as much artistic ability. Like maybe set designing in Maya or animating objects and characters or things like that?

If you feel you aren't artitistic don't let that stop you though. I think anyone can learn anything. It might just take you longer to learn it than someone else.

I also believe that sometimes it takes someone longer to learn something intitially but once they break through they can be better than the person that it came easy to in the beginning.