Heat shrunk fits have huge holding power. Depending on the amount of interference and the thickness of the surrounding metal.

I used to shrink sprocket hubs on shafts for sawmill drag chains. 4.437 shaft with .010 shrink and a 24" sprocket pulling several hundred yards of heavy chain and bark,dust and debris. Easily serveral tons on some occasions.