[INFRA]: Infra ticket automations aren't assigning fields correctly.

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

### Overview

New infra tickets are not being assigned "Needs Triage / Ongoing" as intended in #7261.

### Details

Might be because that automation runs when the issue is opened, and might race with the automation that adds the issue to the project? Merging those workflows into a single "new_issue" automation might be worthwhile.