DNF5 state: latest fails when installing
### Summary

When using `ansible.builtin.dnf` with `state: latest` the previous behavior was to install and update all packages.
Fedora 41 uses DNF5 which does not install the package but instead fails.
A Bug report is filed on the DNF5 repo: https://github.com/rpm-software-management/dnf5/issues/1824
But this may not be reverted because this may be intended behavior.

### Issue Type

Bug Report

### Component Name

dnf

### Ansible Version

```console
$ ansible --version
ansible [core 2.17.5]
  config file = ...
  configured module search path = ['...', '/usr/share/ansible/plugins/modules']
  ansible python module location = ...
  ansible collection location = ...:/usr/share/ansible/collections
  executable location = ...
  python version = 3.12.7 (main, Oct  1 2024, 02:05:46) [GCC 13.3.0] (...)
  jinja version = 3.1.4
  libyaml = True
```


### Configuration

```console
# if using a version older than ansible-core 2.12 you should omit the '-t all'
$ ansible-config dump --only-changed -t all
ansible-config [core 2.17.5]
  config file = [...]/ansible.cfg
  configured module search path = ['[...]/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
  ansible python module location = [...]/python3.12/site-packages/ansible
  ansible collection location = [...]/.ansible/collections:/usr/share/ansible/collections
  executable location = [...]/bin/ansible-config
  python version = 3.12.7 (main, Oct  1 2024, 02:05:46) [GCC 13.3.0] ([...]/bin/python3.12)
  jinja version = 3.1.4
  libyaml = True
Using [...]/inventory/ansible.cfg as config file
CONFIG_FILE() = [...]/ansible.cfg
DEFAULT_HOST_LIST([...]/ansible.cfg) = ['[...]/hosts.yml']
DEFAULT_VERBOSITY(/[...]/ansible.cfg) = 2
EDITOR(env: EDITOR) = /usr/bin/nano
PERSISTENT_COMMAND_TIMEOUT([...]/ansible.cfg) = 30
PERSISTENT_CONNECT_TIMEOUT([...]/ansible.cfg) = 30
```


### OS / Environment

Fedora 41

### Steps to Reproduce

<!--- Paste example playbooks or commands between quotes below -->
```yaml (paste below)

```
- name: Install sssd
  ansible.builtin.dnf:
    name:
      - sssd
    state: latest

### Expected Results

SSSD is expected to be installed.
Documentation: https://docs.ansible.com/ansible/latest/collections/ansible/builtin/dnf_module.html#parameter-state
> Whether to install (present, latest), or remove (absent) a package.

`latest` should install and update the packages

### Actual Results

```console
{
  "failures": [
    "Packages for argument 'sssd' available, but not installed."
  ],
  "rc": 1,
  "msg": "Failed to install some of the specified packages",
  "invocation": {
    "module_args": {
      "name": [
        "sssd"
      ],
      "state": "latest",
      "allow_downgrade": false,
      "autoremove": false,
      "bugfix": false,
      "cacheonly": false,
      "disable_gpg_check": false,
      "disable_plugin": [],
      "disablerepo": [],
      "download_only": false,
      "enable_plugin": [],
      "enablerepo": [],
      "exclude": [],
      "installroot": "/",
      "install_repoquery": true,
      "install_weak_deps": true,
      "security": false,
      "skip_broken": false,
      "update_cache": false,
      "update_only": false,
      "validate_certs": true,
      "sslverify": true,
      "lock_timeout": 30,
      "allowerasing": false,
      "nobest": false,
      "conf_file": null,
      "disable_excludes": null,
      "download_dir": null,
      "list": null,
      "releasever": null
    }
  },
  "_ansible_no_log": false,
  "changed": false
}
```


### Code of Conduct

- [X] I agree to follow the Ansible Code of Conduct