chore: Pinning submodules to commit SHA

[ChaosEternal]

Fixes https://github.com/apache/cloudberry/discussions/1083

What does this PR do?

Pinning the submodules to their commit SHA

Type of Change

• [x] Bug fix (non-breaking change)
• [ ] New feature (non-breaking change)
• [ ] Breaking change (fix or feature with breaking changes)
• [ ] Documentation update

Test Plan

• [ ] Unit tests added/updated
• [ ] Integration tests added/updated
• [ ] Passed make installcheck
• [ ] Passed make -C src/test installcheck-cbdb-parallel

Impact

Checklist

• [ ] Followed contribution guide
• [ ] Added/updated documentation
• [ ] Reviewed code for security implications
• [ ] Requested review from cloudberry committers

Additional Context

CI Skip Instructions

---

[tuhaihe]

Hi, is there any update on this PR? We're nearing the release, but there hasn't been any recent developments. We need to make progress.

If we can't reach a consensus at this time, we can postpone this PR from the 2.0.0 release.

[tuhaihe]

I created a new PR to pin submodule dependencies to specific versions: https://github.com/apache/cloudberry/pull/1212. We can include this PR in the upcoming 2.1 release. Also, feel free to use this as a base for future work.