CSP is a whitelist
A CSP is a list of allowed sources per type (scripts, styles, frames, images). The browser refuses anything outside it, so even an injected tag cannot pull in a remote script. It is the enforcement layer above escaping.
Nonce, not wildcard
Reaching for 'unsafe-inline' or * to make CSP 'work' undoes it, that is the same as no policy. Use a per-response nonce for the inline blocks you actually need. A policy that needs unsafe-inline is a policy not yet written.