Move `make_array`, `array_{intersect, union, distinct} to `datafusion-functions-array`

[alamb]

Draft while I figure out:

• [ ] Get tests passing
• [ ] Review string rewrite / concat in the rewriter and figure out how/why it is necessary (doesn't simplify already do it??)

Which issue does this PR close?

Part of https://github.com/apache/arrow-datafusion/issues/8045 re #9100

Rationale for this change

Set the pattern for how more array functions can be moved from datafusion to datafusion-functions-array crates

What changes are included in this PR?

1. Move make_array, array_intersect, array_union and array_distinct function to datafusion-functions-array
2. Remove vestigal functions around

Are these changes tested?

Yes, by existing tests

Are there any user-facing changes?

No