Chamber drawings are different from cartridge drw
The chamber of the Hornet is 1.415 long
The Fireball has a length of 1.4320.
See Clymer drawings.
I would go with a 22PPC with its proven accuracy record. May as well get the best, same price, and use the fine Lapua 220 Russian cases, lots of people just chamber for the 220 Russian and eliminate fire forming. .
How easy can you get Fireball cases?