AVI is the veteran of desktop video: dependable in 1995, cranky about everything invented since. It was born in 1992, Microsoft, and its real weak spot is modern life: no proper streaming, no subtitles, no love for modern codecs.
MOV is Apple's homebody: gorgeous on a Mac, awkward everywhere else. The QuickTime container; often H.264 or HEVC, sometimes heavyweight editing codecs like ProRes. That makes it the right destination when what you need is shooting and editing on Apple hardware, where it's the native tongue.