So I guess CUSMA is dead?
No, why would it be? It's already in effect, Trump would need to explicitly withdraw from it to make it stop being in effect.
He might do that, of course. He's randomly throwing tantrums and his dementia-riddled brain could come up with any random impulse for him to follow. But this isn't that.