chore: bump crossplane to v1.9.2-up.1

[phisco]

Description of your changes

Bumping to latest 1.9 release from upbound/crossplane.

I have:

• [x] Read and followed Upbound's contribution process.
• [x] Run make reviewable to ensure this PR is ready for review.
• [ ] Added backport release-x.y labels to auto-backport this PR, as appropriate.

How has this code been tested

N.A.