feat: Export Connection CR

[nreisch]

What this PR does / why we need it: Details: https://docs.google.com/document/d/12P3LCaOAQO9Uts4cVljHXkRgukEyWqyLketDP0rFq8A/edit?tab=t.0 Which issue(s) this PR fixes (optional, using fixes #<issue number>(, fixes #<issue_number>, ...) format, will close the issue(s) when the PR gets merged): Fixes #2802

Special notes for your reviewer:

[codecov-commenter]

Codecov Report

Attention: Patch coverage is 31.85841% with 231 lines in your changes missing coverage. Please review.

Project coverage is 38.91%. Comparing base (3350319) to head (de195a3). Report is 385 commits behind head on master.

Files with missing lines	Patch %	Lines
apis/status/v1alpha1/zz_generated.deepcopy.go	0.00%	71 Missing :warning:
apis/connection/v1alpha1/zz_generated.deepcopy.go	0.00%	68 Missing :warning:
...er/connectionstatus/connectionstatus_controller.go	62.99%	39 Missing and 8 partials :warning:
pkg/audit/manager.go	27.50%	28 Missing and 1 partial :warning:
apis/status/v1alpha1/connectionpodstatus_types.go	73.91%	4 Missing and 2 partials :warning:
apis/addtoscheme_connection_v1alpha1.go	0.00%	3 Missing :warning:
apis/addtoscheme_status_v1alpha1.go	0.00%	3 Missing :warning:
apis/connection/v1alpha1/connection_types.go	0.00%	2 Missing :warning:
pkg/controller/add_connectionstatus.go	0.00%	2 Missing :warning:

:exclamation: There is a different number of reports uploaded between BASE (3350319) and HEAD (de195a3). Click for more details.

HEAD has 1 upload less than BASE

Flag	BASE (3350319)	HEAD (de195a3)
unittests	2	1

Additional details and impacted files

@@             Coverage Diff             @@
##           master    #3999       +/-   ##
===========================================
- Coverage   54.49%   38.91%   -15.59%     
===========================================
  Files         134      243      +109     
  Lines       12329    20382     +8053     
===========================================
+ Hits         6719     7931     +1212     
- Misses       5116    11862     +6746     
- Partials      494      589       +95     

Flag	Coverage Δ
unittests	38.91% <31.85%> (-15.59%)	:arrow_down:

Flags with carried forward coverage won't be shown. Click here to find out more.

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

:rocket: New features to boost your workflow:

• :snowflake: Test Analytics: Detect flaky tests, report on failures, and find test suite problems.
• :package: JS Bundle Analysis: Save yourself from yourself by tracking and limiting bundle sizes in JS merges.