[SRW-AQM] Needed update to the latest cmake module on Hera for Rocky8 update.

[drnimbusrain]

DESCRIPTION OF CHANGES:

Required update to cmake module file on Hera for Rocky8 update. See: https://docs.google.com/document/d/1oLqDkslD-99-zpkKD4MtKMmqdm2D4oAo1l7gHHfvKBM/edit?pli=1

Type of change

• [X ] Bug fix (non-breaking change which fixes an issue)
• [ ] New feature (non-breaking change which adds functionality)
• [ ] Breaking change (fix or feature that would cause existing functionality to not work as expected)
• [ ] This change requires a documentation update

TESTS CONDUCTED:

• [X ] hera.intel
• [ ] orion.intel
• [ ] hercules.intel
• [ ] cheyenne.intel
• [ ] cheyenne.gnu
• [ ] derecho.intel
• [ ] gaea.intel
• [ ] gaeac5.intel
• [ ] jet.intel
• [ ] wcoss2.intel
• [ ] NOAA Cloud (indicate which platform)
• [ ] Jenkins
• [ ] fundamental test suite
• [ ] comprehensive tests (specify which if a subset was used)

DEPENDENCIES:

DOCUMENTATION:

ISSUE:

CHECKLIST

• [ ] My code follows the style guidelines in the Contributor's Guide
• [ ] I have performed a self-review of my own code using the Code Reviewer's Guide
• [ ] I have commented my code, particularly in hard-to-understand areas
• [ ] My changes need updates to the documentation. I have made corresponding changes to the documentation
• [ ] My changes do not require updates to the documentation (explain).
• [ ] My changes generate no new warnings
• [ ] New and existing tests pass with my changes
• [ ] Any dependent changes have been merged and published

LABELS (optional):

A Code Manager needs to add the following labels to this PR:

• [ ] Work In Progress
• [X ] bug
• [ ] enhancement
• [ ] documentation
• [ ] release
• [ ] high priority
• [ ] run_ci
• [ ] run_we2e_fundamental_tests
• [ ] run_we2e_comprehensive_tests
• [ ] Needs Cheyenne test
• [ ] Needs Jet test
• [ ] Needs Hera test
• [ ] Needs Orion test
• [ ] help wanted

CONTRIBUTORS (optional):