gh-141749: align exceptions raised by pickle.load with _pickle.load

gh-141749: align exceptions raised by pickle.load with _pickle.load #237767