Quite literally yes. It would've killed GreaseMonkey userscripts and such
Also for power users it should not be a problem at all. Just create your own extension which is literally few simple files and put your userscripts inside that extension. Then load this extension from the chrome and voila.
If you read the MV3 migration guide you’ll quickly realize why. CSP script-src is restricted to self, none, or localhost sources for all non-sandbox pages, content scripts included.
https://developer.chrome.com/docs/extensions/mv3/mv3-migrati...
Time to package a JavaScript interpreter into wasm and run it within the extension.
It's very inefficient and it's a pain to write, but it is possible.
I suspect they will not approve extensions that do this if it becomes popular.