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