A collection of `array_agg` improvements and issues

[alamb]

I found myself looking around for related issue to array_agg so I figured I would make an epic to track them

• Slow aggregrate query with array_agg, Polars is 4 times faster for equal query #17446
• Incorrect memory accounting in array_agg function #16517
• Implement GroupsAccumulator for array_agg aggregation function #10145
• Address memory over-accounting in array_agg #16816
• Support multiple ordered array_agg aggregations #16625
• Fix array_agg memory over use #16346