Not ambiguous. Cancel means don't mount the DMG, but don't move it to the trash either. There is no 'Proceed Anyway' option, unless you enable it in System Preferences.
Which is a problem. Suppose I want to run an app that I trust, but Apple does not. I'm going to go find the option in System Preferences and turn it off so it stops bugging me, then probably never turn it back on.