Interesting idea for a game.
First off, I think it would be smarter for you to get some criticism on the sprite itself before worrying about animation. Otherwise, you're going to have to change all those animations later if you want to fix the issues people will point out in regards to the wizard sprite. I think there's a lot of potential for improvement.
As far as the walking cycle, my first advice is to just google walking cycle. Look for animation guides, it's all the same whether it's cartoons or pixel art. Look at tutorials on Youtube. Look for some tutorials on PixelJoint, perhaps. Right off the bat:
- The hood and robe are moving very rapidly and unnaturally, when they should be flowing slowly.
- His hips and upper body should be moving up and down as he walks. Walking is basically falling forward, then moving your foot forward to break the fall, lifting yourself upward and falling forward again for the next step.
- His hand is just moving up and down, when it should be swinging back and forth . Most people move their right arm forward when they move their left leg forward. As the hip turns when you walk, the shoulders turn in the opposite direction.
Long story short: Look at tutorials. All this stuff is explained in great detail elsewhere, no need to wait for someone on this forum to explain it all