There is no question that the joint has been poorly made.
What matters when it cones to rectification is why. Poor technique or poor bonding materials selection is easily rectified by clean up and being more careful. If it’s a dimensional issue with too much clearance the problem will take much more fixing.
As Duncans story shows properly fitted and bonded Loctite joints are immensely strong. Like adhesive tape its not so much the absolute strength of the bonding material that does it more the large area covered. I was always advised to use heat before attempting to break a Loctite bond. The scrappy got a couple of things that never did come apart.
What to do if the clearance is excessive?
Could a tolerance ring and pin / key be made to work?
Or maybe a sort of double joint with a Speedie sleeve (the thin stainless steel sleeves used to repair a shaft that has had a groove worn in it by an oil seal) round the journal fitting into slightly enlarged bore in the wheel. Well made bonds should be amply strong enough even despite the two layers.
Key or pin shearing is pretty much a non issue, unless it’s vastly undersize, so long as everything fits firmly without clearance. It’s excess clearance allowing a bit of movement that shears keys. As ever the objective is to get as close to a “solid piece of metal that be taken apart” as possible. In many respects round pins and dutch keys are more resistant to shearing due to the load distribution.
A flat key can be thought of as taking all the load at the joint line.
A round pin distributes it better. It’s not completely inaccurate to consider that much of the force applied to a round pin is trying to stretch the bore up and over the pin rather than simply trying to shearing it.
Vastly oversimplified thought experiments of course.
Clive