CMake: remove restriction which avoids nvcc + clang + mdspan #6477

Job	Run time
clang-format	18s
linux_clang-14_cuda-11.2_debug_analysis	21m 16s
windows_cl-2022_debug_analysis	2h 31m 26s
macos_xcode-15.4_debug_analysis	18m 37s
linux_gcc-12_debug_analysis	21m 36s
macos_xcode-15.4_release	14m 50s
macos_xcode-16.1_debug	12m 11s
windows_cl-2022_release	2h 28m 6s
windows_cl-2022_debug	2h 27m 2s
linux_gcc-11_debug	20m 29s
linux_gcc-12_release_c++20	19m 58s
linux_gcc-13_debug	23m 31s
linux_clang-13_release	17m 53s
linux_clang-14_release	21m 23s
linux_clang-15_debug	14m 47s
linux_clang-16_debug_ubsan	18m 27s
linux_clang-16_debug_tsan	16m 41s
	11h 28m 31s

Provide feedback