Yes. Asking for the root password is the only sensible action an unconfigured sudo can take.
Removing the targetpw and ALL line restores the “normal” behaviour for sudo by asking for the invoking user’s password.
The essence of correctly using sudo is to create rules which specify precisely what a user may do with root privileges.