[FEA]: Implement P2165 "Compatibility between tuple, pair and tuple-like objects"

### Is this a duplicate?

- [x] I confirmed there appear to be no [duplicate issues](https://github.com/NVIDIA/cccl/issues) for this request and that I agree to the [Code of Conduct](CODE_OF_CONDUCT.md)

### Area

libcu++

### Is your feature request related to a problem? Please describe.

We have started implementation of this feature but we need to implement all of it.

What is currently missing:
* `pair` constructor / assignments
* `tuple_cat` extension
* `basic_common_reference` for _tuple-like_

### Describe the solution you'd like

We should be conformant to C++23 tuple

### Describe alternatives you've considered

_No response_

### Additional context

_No response_