The current emacs-29 generates no such autoloads file, because the sicp package defines no autoloads. But in general the -autoloads.el file is nevertheless needed, at least for its load-path logic. Contrast this with a package that defines even a single autoload cookie, such as the bluetooth package on GNU ELPA. In this case emacs-29 does TRT: