The same confirmation message is used for deploy with or without the --no-exec option:

CloudFormation will make the following changes:

<changes>

Do you wish to continue?

In the case of --no-exec the message is confusing as it seems like the changeset WILL be executed when responding y. It's also not obvious that the changeset will be deleted if the user respond with n.

For my use case, I would be happy if no confirmation were provided - I'm already doing that by reviewing the changeset prior to executing.

Happy to submit a small PR if you'd like!