CC: @trilinos/framework, @sebrowne
Enhancement
It has been since Feb 2023 that Trilinos upgraded the min CMake version to 3.23 (see #11583).
CMake 3.23.0 was released in March 2022 (see https://github.com/Kitware/CMake/releases/tag/v3.23.0).
Given that CMake 3.28 was released in Dec 2023 (see https://github.com/Kitware/CMake/releases/tag/v3.28.0), it seems reasonable to upgrade the minimum CMake version of Trilinos and TriBITS to CMake 3.28 or newer.