fix(misconf): load only submodule if it is specified in source

[nikpivkin]

Description

This PR fixes module loading behaviour. Now if a submodule of a remote module is specified in the source, the module resolver returns the submodule directory, which eliminates evaluation of unnecessary blocks.

Related issues

• Close bug(misconf): Incorrect terraform submodules scanning #7113

Checklist

• I've read the guidelines for contributing to this repository.
• I've followed the conventions in the PR title.
• I've added tests that prove my fix is effective or that my feature works.
• I've updated the documentation with the relevant information (if needed).
• I've added usage information (if the PR introduces new options)
• I've included a "before" and "after" example to the description (if the PR is a user interface change).