There are opposite views and feature request about this:
https://community.rws.com/ideas/tridion-ideas/i/tridion-sites-ideas/permanent-publish-data
I would like to get more insights from the community to understand why you would want to preserve or auto-delete publish transaction data. There seem to be customers that will need to preserve more information about the content lifecycle including when content was published, republished and unpubilshed, as well as some voices that just see historic publish transactions as clutter.