The question missed the version of SQL Server targetted, however, this behaviour is still confusing.
From books online:
However, the text will be available to privileged users that can either access system tables over the DAC port or directly access database files. Also, users that can attach a debugger to the server process can retrieve the decrypted procedure from memory at runtime. For more information about accessing system metadata, see Metadata Visibility Configuration.
(http://msdn.microsoft.com/en-us/library/ms187926.aspx)
Wouldn't we call viewing the execution plan a debugging exercise?
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins