I'm not aware of any Mac user among my friends who isn't aware of this.
Most OSS installers but even many commerical ones aren't code signed because devs don't want to pay the Apple tax.
I don't think any of my non-tech friends would know this.
As much as I love to hack and tinker with my OS, I also appreciate the safety inherent in the Apple ecosystem. That's why even as a life-long Windows user, I bought my Dad an iPad - I know the chance of him getting p0wned via some social engineering attack and having his banking password stolen are a lot lower than with a Windows or Android tablet.
Disabling SIP is generally a bad idea, but there are times when it can be useful, e.g. modifying stock applications like Dock.app.
You don't need to disable SIP to run unsigned code. If a binary is unsigned all you need to do is hold a key down while clicking the program. macOS will show a warning popup and let you continue. This isn't super user friends, but then again the majority of Apple's customers are not going to (or want to) run untrusted code, and if you do want to run untrusted code it is not that big of an inconvenience.
I think if you want to just run any code you want, you sudo spctl --master-disable. I’ve never had to use it.
This still reads like all or nothing. All as in "App Store and identified developers", or user can turn off "System Integrity Protection" completely. Turning off SIP eliminates any protection.
Is that what it means to disable SIP?