I figured it came from a similar expression like "happier than a pig in shit" implying the person is happy about something they really shouldn't be happy about.
If you lived in the country before TV, internet, gaming, or even electricity, you would probably have seen a lot more possums especially when you're hunting them for tomorrow's dinner.