Am I supposed to press down on the Porter Cable PXRA2676 Restorer to use it and if so how hard?

No.  As with most sanders, let the tool weight do the work for you.  Just maintain a firm grip on the handle(s) during use.