fix(types): load a declared ESM-only host package through a strictly-tighter hostRoot node_modules walk, and split the failure kind

fix(types): load a declared ESM-only host package through a strictly-tighter hostRoot node_modules walk, and split the failure kind #9774