I suppose that if a campground pedestal was wired INCORRECTLY, with hot and neutral reversed on one plug, that this type of adaptor would short circuit. Having said that, I expect the pedestal breakers would protect the adaptor since they should trip instantly. Still, it could get ugly at pedestal.
Beyond that, I’m not sure how using this kind of adaptor could overload a 50-Amp motorhome system. That’s not to say there are not other potential risks I’m not thinking of.