[FEA]: Improve agent skills to account for tile support

### 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

Infrastructure

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

Our agents have great skill files to work with that greatly improve the ability of code generation and our coderabbit review bot.

However, with tile support there are wholly new constraints we have to consider during development and review.
There are many additional constraints for tile code. No asm, limited support for builtins, no extended floating point support.

We need to make sure that those additional constraints are in the skill files so that the AI finds those repetitive issues

### Describe the solution you'd like

We need to update our skill files to add the additional constraints for tile C++.

The coderabbit bot should be able to e.,g flag use of ptx / asm in a `_CCCL_API` function and suggest marking it as `_CCCL_HOST_DEVICE_API`

### Describe alternatives you've considered

_No response_

### Additional context

_No response_