[7.2.0] Revert special handling of yanked module files

[bazel-io]

Forked from #22083

[bazel-io]

Cherry-pick was attempted but there were merge conflicts in the following file(s). Please resolve manually.

src/main/java/com/google/devtools/build/lib/bazel/bzlmod/ModuleFileFunction.java

cc: @bazelbuild/triage

[iancha1992]

Cherry-pick was attempted but there were merge conflicts in the following file(s). Please resolve manually.

src/main/java/com/google/devtools/build/lib/bazel/bzlmod/ModuleFileFunction.java

cc: @bazelbuild/triage

cc: @fmeum @Wyverald @meteorcloudy

[bazel-io]

Cherry-picked in https://github.com/bazelbuild/bazel/pull/22263