Although your mobo has a bunch of 4-pin fan headers that look alike, they are divided into three quite different types, and need to be used for the correct fans.The first group are the CPU_FAN and CPU_OPT headers that are guided by a temperature sensor inside the CPU chip. These are to be used only for cooling the CPU chip. Second is a single AIO_PUMP header to be used only for the PUMP part of an AIO system. Lastly there are FOUR CHA_FAN headers that are guided by a different temp sensor on the mobo. You should plug your CASE VENTILATION fans into these headers. Do NOT plan to plug ALL your fans into one Fan Hub.
Your AIO system is designed a little different from many others. There are TWO cables from the PUMP unit to connect. One goes to a mobo USB2 header, and it provides power to that pump and a communication channel to it from a software utility that you run under Windows. The second goes to a small socket on the Fan Controller Box, and this is how that box communicates with that software tool. You actually do NOT plug anything from this AIO system into the mobo CPU_FAN, CPU_OPT, or AIO_PUMP_ headers.
Now, the Fan Controller box also has other connections to be made. It has a wide socket on one end where you plug in a SATA power output connector from the PSU to supply power to the box, its fans and the fan lights IF you have lighted fans. It has a cable to connect from a socket to a mobo ARGB header for control of light displays in the fans IF you have lighted fans. And of course, it has four sockets each for the motors and the lights of four fans.
Note that connecting things this way as intended can cause a small issue mentioned in the system's manual. The mobo CPU_FAN header expects to receive a fan speed signal from its fan and will warn you prominently if it has NO such signal. That WILL happen here because there is nothing plugged into that header. The manual advises you to go into BIOS Setup for that CPU_FAN header (see below) and DISable monitoring of fan speed so you do not keep getting that warning.
NOW we come to your other fans used for general case ventilation - 3 side, 3 bottom, 1 rear. These should be connected to some of the four CHA_FAN headers. I suggest you get two simple SPLITTERS with 3 output arms each, similar to this
https://www.amazon.com/Splitter-Extension-Converter-Sleeved-Computer/dp/B0B398L8V5/ref=sr_1_2?crid=QCPP2Y461032&keywords=fan+splitter+4+pin&qid=1678384208&sprefix=fan+splitter,aps,103&sr=8-2
Note that these are SPLITTERS. Each has one input connector to plug into a mobo fan header, and three outputs for fans, and NO other connections. A HUB is a different type of device that also has a third connection arm that goes to a SATA power output from the PSU; you do NOT need one of those. I suggest you use one of these to connect the three bottom fans to one CHA_FAN header, the other for the three side fans, and connect the single rear fan just to a third CHA_FAN header. Configure all of these exactly the same and all those seven fans will do the same thing. The max current draw specs for your fans are 0.09A, so having three of them connected to a single header using a Splitter is entirely acceptable - each header limit is 1.0 A max load.
Get the BIOS Manual for your mobo here if you don't have it already
https://dlcdnets.asus.com/pub/ASUS/mb/LGA1700/ROG_MAXIMUS_Z790_HERO/E21287_ROG_Z790_Series_BIOS_Manual_EM_WEB.pdf?model=ROG MAXIMUS Z790 HERO
Go to p. 6 to start. To enter BIOS Setup I find you should HOLD DOWN the DEL key immediately after start-up so that the keypress is recognized and you do get in; release when the opening screen shows. In EZ Mode click on QFAN Control at bottom centre to reach the QFan screens (p. 80). In Advanced Mode click on Monitor in the top menu list, then on p. 79 choose QFan Configuration. There you can choose each fan header and configure it separately. For the CPU_FAN header, you only need to set the CPU Fan Speed Low Limit to "Ignore" so you will not get warnings as above. For each CHA_FAN header in use, I suggest you start with:
PWM Mode ( for 4-pin fans)
STANDARD Profile - automatic control of speed according to mobo temperature using pre-set "curve" of fan speed versus temp
Chassis Fan Q-Fan Source set to Motherboard
Chassis Fan Speed Low Limit to 300 RPM but adjust if this allows your fans to stall without warnings
After making all your adjustments, use Esc back to the Main Menu, then F10 to reach the Exit Menu (p. 99). There choose Save Changes & Reset to save your settings and reboot.