FLV is a relic of the Flash era: the format YouTube grew up on, stranded when Flash died. It was born in 2002, Macromedia (later Adobe), for Flash Player, and its real weak spot is playing anywhere at all since Flash was switched off in 2020.
AVI is the veteran of desktop video: dependable in 1995, cranky about everything invented since. Audio Video Interleave: an early container that predates streaming and most codecs you'd use today. That makes it the right destination when what you need is opening old archives and humoring legacy Windows tools.