When sql server starts to execute the code it validates the script...

Validated NOT executes

so the steps are

1. validate exec statement -> ok, continue (DO NOT EXECUTE)

2. Validate insert statement -> VALIDATION ERROR no such field exists