ENH: make `_explode` a method of the `ExtensionArray` interface

[douglasdavis]

Feature Type

• Adding new functionality to pandas

• Changing existing functionality in pandas

• Removing existing functionality in pandas

Problem Description

In awkward-pandas we've had a user expect explode to work for them; see intake/akimbo#38

I see in #53602 Series.explode support for extension types has been added specifically to PyArrow list types. We'd like to be able to support explode with our awkward extension type. Therefore this feature request is to make an ExtensionArray._explode method, with a default that provides the same behavior already provided by Series.explode for non object dtypes (that is, a copy).

Feature Description

Issue will come with accompanying PR.

Alternative Solutions

None to my knowledge

Additional Context

No response