Just going to leave this solution here in case anyone stumbles upon the same issue.
As stated in this question:
https://community.render.com/t/cors-axios-call-from-static-site-to-express-js-backend-blocked/3460
removing the port from the URL connection fixed the issue. My API is served on port 3000 and i had this in the connection string. Removing it fixed all issues