The joke is a pun. A human cannonball is a person who performs an act in a circus or similar show by getting fired out of a cannon. Finding someone of 'the right caliber' means finding someone who has the proper quality or level of ability. 'Caliber' also means the internal diameter or bore of a gun barrel.
When the human cannonball retired they couldn ' t find a replacement of the right caliber .