Light pressure is all that is required. You do not need to apply excessive pressure as this depresses the skin and changes the angle of insertion of the micro needles.
Good sharp quality needles will pass easily through the skin with reasonably light pressure making a treatment far easier to perform.