I spent many years (about 8 years) as a Cub Leader (here in Australia, we have Joeys for the 5 - 7's, Cub Scouts for the 7 - 11's, Scouts for 11 - 15) and most of the leaders were women.
I think that the main criteria for any successful leader is that they are enthusiastic, and have the ability, and desire, to interact with the cubs on their level.
My own interests in science fiction and fantasy held me in good stead - I could discuss the "in" cartoons of the time and i considered it part of my role to actually watch some of the Saturday morning cartoons.
Your programs should be easy to follow, and full of "doing" rather than listening (they listen enough at school!). My most successful program was based on Star Trek - the cubs were an Enterprise away team exploring a new planet. There I had mapping, codes, tracking, singalling all rolled into one evening. The boys loved it (I know this, because I still see some of them (20 years later!!!) and they tell me that they remember it as being a great night).
You'll love being involved and it's something that stays with you all your life. I still grin when I remember interviewing (professionally, I'm a recruitment consultant) a graduate engineer who was one of my cubs - and he insisted on calling me Bunyip (my scouting name)!