Okay, I couldn't wait and tested this. Yes, indeed Motion JPEG recorded on my Nikon D5000 does import and playback on the iPad.
Is the motion jpeg container .avi on your camera? If so does the camera kit recognize it? My casio does mjpeg video in .avi. My camera kit has been shipped. I'm hoping it will import my videos. iTunes won't.