My website is not loading after turning on the CSP settings

You will need SSH access to your site, and open the Rails console with:

cd /var/discourse
./launcher enter app
rails c

Then,

SiteSetting.content_security_policy_script_src = ""

This will reset your CSP setup back to default, and you should be able to get back to your site.