You'd normally expect only one shearpin to break, and that would stop the action, so something quite complicated must've happened to break both.
I don't think I'd want to make a leadscrew myself, but that's because I prefer to concentrate on product for family and friends, and don't like to invest lots of time on tooling projects.
But as far as I can see it should be a practical proposition. If there's a way to do it (and I've not taken the crosslide off for examination), I'd try to avoid jamming on the far end of crosslide travel by having it simply run off the end of the leadscrew like my Myford Speed 10 used to rather than hitting a solid stop. And maybe use a smaller shearpin to reduce the damage from outward facing up against the handwheel bearing housing as seems to've happened to you.