Support new stage RC 2 for 4.7.4 in wazuh-packages repository

Description

This issue attempts to support a new stage RC 2 for 4.7.4 in the wazuh-packages repository.

[x] Ensure changelog is updated for 4.7.4 (if applicable).
[x] Bump revision for branch 4.7.4 on wazuh-packages repository.
[x] Add release ETA
- https://github.com/wazuh/wazuh-packages/pull/2928
[x] Create tag v4.7.4-rc2 from branch 4.7.4 on wazuh-packages repository.
[x] Create and publish a pre-release: https://github.com/wazuh/wazuh-packages/releases/tag/v4.7.4-rc2.