Air does not work well. Since the tool will change loads, entering and exiting, you will get a build up of air pressure in the CYl that will release once the drill starts breaking through. This will jam the bit through once the tip penetrates the part. You need something less compressible. Think hydraulic, or air over oil.
Honestly, now days, it may be cheaper to use a stepper motor with something like arduino to control it.