Update to CPM 0.40.2 to fix CMake 3.30 deprecation warnings

[robertmaynard]

Description

Updated to CPM version 0.40.2 so that we don't se any policy CMP0169 ( FetchContent_Populate() is deprecated ) warnings

Checklist

• [x] I am familiar with the Contributing Guidelines.
• [x] New or existing tests cover these changes.
• [x] The documentation is up to date with these changes.
• [x] The cmake-format.json is up to date with these changes.

[robertmaynard]

/merge