CLN: Remove pickle support pre-pandas 1.0
For a major pandas 3.0 release, I think it's reasonable that pickle support for pre-pandas 1.0 can be removed by now.
I'm going to break up this PR. I cannot track where the failures are coming from.