The scorpion and the frog is my favorite fable, but I have no idea what the moral is supposed to be. It just seems like a hilariously nihilistic shaggy dog story.
But as an adult, it seems like a rare (and perhaps valuable?) counterpoint to "don't judge other people" or "don't judge a book by its cover." Sometimes... those behaviors are adaptive.
I think the moral is supposed to be: "Some people are just irredeemably awful to the point that they'll self destruct and take you down with them if you try to help them" which... I guess is true but pretty jaded for a children's story, haha. Although, old fashioned fables do tend to have that dark aspect.