Update ansible version for production environments provisioning

[kencho51]

Describe the bug
A clear and concise description of what the bug is.

Warning: ansible@8 has been deprecated! It will be disabled on 2024-12-14.

Update the currently using ansible version to the latest, the package release 8 or core version 2.15.x has EOL already , details at here.

Additional context
Add any other context about the problem here.

The following issues may related to the EOL ansible version is used.

Reported issue:

1. Ansible bastion playbook tooks unexpectedly long time to complete, >2hrs

 % ansible --version
ansible [core 2.15.12]
  config file = None
  configured module search path = ['/Users/kencho/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
  ansible python module location = /Users/kencho/Library/Python/3.9/lib/python/site-packages/ansible
  ansible collection location = /Users/kencho/.ansible/collections:/usr/share/ansible/collections
  executable location = /Users/kencho/Library/Python/3.9/bin/ansible
  python version = 3.9.6 (default, Oct  4 2024, 08:01:31) [Clang 16.0.0 (clang-1600.0.26.4)] (/Library/Developer/CommandLineTools/usr/bin/python3)
  jinja version = 3.1.4
  libyaml = True

2. DB timeout after a long time of running bastion_playbook when resetting database from backup when provisioning bastion from PR Upgrade centos version in production environments #1998's branch, the ansible version is 2.15.9.

[kencho51]

After upgrade the ansible to the latest using brew install ansible,

% ansible --version                                         
ansible [core 2.18.1]
  config file = None
  configured module search path = ['/Users/kencho/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
  ansible python module location = /opt/homebrew/Cellar/ansible/11.1.0/libexec/lib/python3.13/site-packages/ansible
  ansible collection location = /Users/kencho/.ansible/collections:/usr/share/ansible/collections
  executable location = /opt/homebrew/bin/ansible
  python version = 3.13.0 (main, Oct  7 2024, 05:02:14) [Clang 16.0.0 (clang-1600.0.26.4)] (/opt/homebrew/Cellar/ansible/11.1.0/libexec/bin/python)
  jinja version = 3.1.4
  libyaml = True

the playbooks will throw this warnings:

[WARNING]: Collection prometheus.prometheus does not support Ansible version 2.18.1

The issue has been reported to prometheus-community/ansible#490