The failure is in fact sphinx-automodapi related and not sphinx-astropy, but nevertheless I open this issue as a fyi in case anyone sees the failure.

https://github.com/astropy/sphinx-astropy/actions/runs/18812204892

Upstream issue: astropy/sphinx-automodapi#219