Is a CSP enough to secure my payment pages?
No. A CSP restricts script sources but cannot tell whether an allow-listed script has been tampered with. PCI DSS 6.4.3 and 11.6.1 expect you to both manage which scripts run and monitor their integrity and behaviour; the second half is what a CSP does not provide.