Great News!!! I reached out to SQSP Support again with the link to this discussion, and this time they escalated the ticket and fixed it within a couple of hours!! They said it may take up to 24 hours for it to activate across the system, but I checked and acuityscheduling-mail.com is already showing as having a valid SPF record 🙌
If at first you don't succeed - try again 😉