You can use multiple hourly triggers only with an Enterprise subscription.
The Super Pro subscription allows you to run one refresh per day per sheet. If you create more than one trigger per day with a Super Pro subscription, only the first one will complete. Pro level licenses do not support hourly or daily refreshing at all.
See Trigger License Limitations for Google Sheets for more details.