[C++][Python] Expose recursive flatten for lists on list_flatten kernel function and pyarrow bindings

[ZhangHuiGui]

Describe the enhancement requested

Support flatten recursively for kernel function list_flatten and related pyarrow bindings.

Two things should be included:

1. We should support an option for deciding whether to recursively flatten a list. This option should default to false for list_flatten and pyarrow bindings.
2. Expose the FlattenRecursively api which comes from (GH-41055: [C++] Support flatten for combining nested list related types #41092) to pyarrow related LogicalList Array bindings.

Component(s)

C++, Python

[felipecrv]

Issue resolved by pull request 41295
#41295