📦🧪 Simplify the RPM spec

[webknjaz]

This patch removes the SRPM-vendored PyPI-sourced dependencies and migrates packaging to rely on pyproject-rpm-macros under RHEL.

Previously, this set of helpers was only in use on Fedora.

This move allows us to get rid of a lot of conditionals that were making people's lives difficult.

[Jakuje]

This is quite large overhaul, but looks like working good (except for some lints). Read through the change and did not notice anything off.

[Copilot]

Pull Request Overview

This PR simplifies the RPM spec file by migrating RHEL packaging to use pyproject-rpm-macros instead of manually vendoring PyPI dependencies. The change aligns RHEL packaging with the existing Fedora approach, eliminating complex conditionals and manual dependency management.

• Removes all vendored PyPI source dependencies from the RPM spec
• Standardizes build process to use pyproject-rpm-macros across all distributions
• Simplifies CI/CD workflows by unifying build steps for all distro types

Reviewed Changes

Copilot reviewed 4 out of 4 changed files in this pull request and generated 1 comment.

File	Description
packaging/rpm/ansible-pylibssh.spec	Removes RHEL-specific vendored dependencies and conditionals, adopts unified pyproject build approach
.github/workflows/ci-cd.yml	Simplifies CI matrix and build steps, removes distro-specific conditionals
docs/changelog-fragments/759.packaging.rst	Documents the RPM spec simplification changes
docs/changelog-fragments/759.contrib.rst	Documents the CI/CD workflow improvements

---

_{Tip: Customize your code reviews with copilot-instructions.md. Create the file or learn how to get started.}

[webknjaz]

@Jakuje yep, there were a lot of ancient hacks and it took some time testing what can be removed from the spec. It was late yesterday, so I got to finishing minor linting tweaks just today. I'll let it run the CI once more before merging.