More profitable to sell you a new fly rod, maybe?
I agree it should be a simple repair. Heat old epoxy to remove it and threads and whatever might remain of old snake guide. Reverse the process for the new snake guide.
Maybe try to locate a local rod builder who would do it for you? I don't know anyone in the NW area of PA who builds rods, but I'm sure someone on this site does or builds them. Or give it a try yourself..