/execute is performed on the command issuer, not the target

/execute in a command block is performing in-line command from the command block instead of the selected entity/item

execute @e[type=zombie,tag=Bob] ~ ~ ~ testfor @p[r=2]

When near Bob, nothing happens. When near command block (repeat, unconditional, always on) achieves output.