The first INSERT succeeds because both "CTId = 1" is TRUE and "Goal IS NOT NULL" is TRUE.

The second INSERT fails because "CTId = 1" is not TRUE.

The third INSERT fails because "Goal IS NOT NULL" is not TRUE.

Since you have "AND" in the test, both conditions must be TRUE for success.