UPDATE:
I’ve been talking with Google and had a call with them. They were confused why the tag wasn’t firing correctly even after correct installation. We ran out of time and had to reschedule for another appt. I was able to get ahold of Shopify about the CSP issue and they told me Google tag manager won’t work on any shopify stores that aren’t on a shopify plus plan. We’ve had our same plan since 2015 and have been grandfathered in with really good rates and things, so we have no interest in swapping to a different plan that does little for us aside from making us pay more for less. However, this poses a serious issue now that we can’t connect our site to GA4. Don’t know if anyone else is on a custom plan too, or even just not a shopify plus one, but just throwing it out there as another potential to look at for anyone else still struggling with this.