I use a Rotary for everything and even with the ultimate power correcting tool, if I decide to use a less aggressive compound/pad combination, to eliminate a 2nd step for example, I will have to press down pretty hard (depending on the amount of correction, and the hardness of the paint) to get the compound to work faster and better and break down (if it does break down), and start polishing the paint.
So, yes, you do need a certain amount of pressure on the machine to get it to rub the paint harder and get a more complete level of correction and finishing.
This all comes from experience and no amount of videos are going to give this to you as much as practicing on something (as has been mentioned above), or getting to work with someone who is very experienced and does excellent work consistently.. Or, getting to practice on a lot of vehicles that are safe to use for practice...
You need to see a variety of situations and conditions and either experiment or best case, have someone there to show you and then you do it until you get it.
And as has been said ad nauseum - you must be constantly innovative if you want to be good at this to improve your skillset.
It will never be a mindless operation of a machine, not thinking of or watching what is happening and just depending on the machine to do it all for you..
Where do you live? Perhaps there is someone here that is really good and will be happy to have you come by and learn???
Good luck with this !
Dan F