Will the PSPO stop me from exercising my dog off of a lead?

No.  Dogs can be exercised freely in parks and open spaces (except for gated children’s playgrounds and gated sports areas) as long as they are still under the control of the owner.