But, every RV park with "50 amp RV service is a 40 amp continuous capable plug-in spot.
Not based on personal experience, but there are reports of campground NEMA 10-50 outlets often being in poor shape.
If you try to get the full 40A continuous from them overnight, you may wake up to find that the circuit-breaker has cut off the charge. Or, there's no circuit-breaker, but a fuse has blown and it takes forever to get it replaced.
The Tesla charger is smart enough with the current firmware to reduce the charge speed if a voltage drop is detected. This is usually enough to prevent the breaker trip / fuse blow scenario so you wake up with a charged vehicle even if it isn't at the full rate.
Shouldn't we expect similar firmware/charger code to do the same when the next gen Leaf comes out?
Assuming so you can have a higher KW charger and let the charger/evse combo worry about how safe the circuit is.
7.2KW charger is 33A on that supposedly 40a circuit at the RV Park and shouldn't even need to kick in a lower charge level but could drop down to 27A if a problem is detected and pretend it is a 6.6KW charger.
9.6KW charger is well over the 40a limit but it could start at 40a and drop to a lower charging rate if a problem is detected.
Oh and if you have the option to manually dial down the amps before charging starts you can plug into the 14-50 and decide how safe you want to play it. If you know 25a will charge you before you need to leave you can be ultra conservative. If you know you need to leave asap you can let the firmware start high and hope it will pull back before the breaker/fuse have to do their thing.