Do I need to subscribe to sync or otherwise use pwSafe?

No, the subscription is just for pwSafe Cloud. Although we think pwSafe Cloud adds great value to pwSafe, you don't need to subscribe to it to have a fully-functional password manager, including access to Apple's iCloud Drive for syncing. You'll be missing only Cloud Memory and Cloud Backups.