Is your feature request related to a problem or challenge? Please describe what you are trying to do.

Related to #8082. Followup of #8361 to implement array variant shredding

Describe the solution you'd like

Extend shred_variant so array variants can be shredded into List, LargeList, ListView, and LargeListView.

Describe alternatives you've considered

Additional context

Array shredding spec