It's more of a "prevent app developers from asking you to do it". A normal user that has to disable SIP is a lot more of a barrier than a normal user typing in the root password.
Normal users need UX to save them from owning themselves.
Exactly! But if you're an even slightly advanced user, this isn't necessary.
I'm a little frustrated by all the FUD I've seen spread in Apple enthusiast communities about how SIP is this super important security feature that should never be turned off.
My opinion is that if you have a reason to disable SIP, go ahead and do so with a clear conscious. You will continue to be protected by the privilege system that's in place for (basically) all UNIX's.
Normal users need UX to save them from owning themselves.