With merging, you can select which items you want to consolidate; with flattening, all visible items in the artwork are consolidated in a single layer.
With either option, the stacking order of the artwork remains the same, but other layer-level attributes, such as clipping masks, aren’t preserved.