Add workflow to test Airflow RC

[pankajastro]

closes: https://github.com/astronomer/astro-sdk/issues/1950 mostly taken from https://github.com/astronomer/astronomer-providers

[codecov[bot]]

Codecov Report

Patch coverage has no change and project coverage change: +0.07% :tada:

Comparison is base (c593075) 89.67% compared to head (9cb8da3) 89.74%. Report is 2 commits behind head on main.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #1995 +/- ## ========================================== + Coverage 89.67% 89.74% +0.07% ========================================== Files 72 72 Lines 4262 4262 Branches 530 530 ========================================== + Hits 3822 3825 +3 + Misses 343 341 -2 + Partials 97 96 -1 ``` | Flag | Coverage Δ | | |---|---|---| | PythonSDK | `89.74% <ø> (+0.07%)` | :arrow_up: | Flags with carried forward coverage won't be shown. [Click here](https://docs.codecov.io/docs/carryforward-flags?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=astronomer#carryforward-flags-in-the-pull-request-comment) to find out more. [see 1 file with indirect coverage changes](https://app.codecov.io/gh/astronomer/astro-sdk/pull/1995/indirect-changes?src=pr&el=tree-more&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=astronomer)

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