module: improve error for invalid package targets

For targets that are strings that do not start with ./ or / the error will now have additional information about what the programming error is.

Closes: https://github.com/nodejs/node/issues/32034

PTAL @nodejs/modules