Answer:
In this context, prove means, turns out to be. Undoing means ruin, disaster. So if something proves to be someone's undoing, it means that this thing, whatever it is (a life of crime, drug addiction, compulsive gambling, etc.) has ruined someone's life. Heroin addiction proved to be Frank's undoing.