You downloaded the wrong rpm. See in the quote above it says EL8, you need the EL9 rpm or you use the RHEL9 repository from the link I provided. The python libraries will be found when you have the correct rpm.
EDIT:
after checking now, you cannot download the EL9 rpm. You have to use the repository which is accessible here: https://dev.mysql.com/downloads/file/?id=511985 however this also doesn’t seem to have a workbench version to install.
So until they release one, it cannot be installed it seems.