If a scammer said go to a cliff and jump they would do it…
Yep. And there's history. Years ago, there was the
Beagle/Bagel virus which infected a lot of computers. In order to avoid detection by antivirus scanning software, some variants would transmit itself as an e-mail with the payload in an encrypted Zip file. The body of the e-mail directed users to save the attachment, unpack the zip file (with the password provided in the mail), and then execute the contents.
Far too many people obeyed and got infected. So yes, some people will do anything they're told to do, without giving it a single thought. But everybody makes occasional mistakes, and a feature like this will give them a chance to reconsider.
People and their (perhaps less tech-savvy) relatives should be aware of the "pastejacking" scam which is becoming more common. You come across a website (could be one mostly legit but with pages now hacked), asking you for a "verification".
I came upon one recently. It throws up an "I am not a robot" button to click, while at the same time dumping some text into your clipboard via javascript (which is actually a shell script command obscured from casual inspection by being encoded as base64). Underneath the "I am not a robot" button there are further instructions that ask you to, basically, open the Terminal app and "press certain keys".
And this is exactly what this new feature is designed to protect against. It can be especially nasty, because the text copied to the clipboard doesn't come close to resembling the text on the web page, which the user (presumably) thinks he's copying.
The only thing Apple should change here, is the warning dialog should have a button to show what would be pasted, so you can see it before deciding what to do. So if I'm copying instructions from a web page (e.g., a tip from a user in a forum), I want the warning, but I also want to make sure I'm pasting what I think I'm pasting.