Tests/RunCMake/CXXModules: require transitive usages

Clang 17 is in a transition where it warns about transitive usages. Turn
it into an error if the flag is available to make sure we're testing the
feature properly.