A lot of closed questions do get deleted automatically. They have a few metrics to decide which questions to keep: https://stackoverflow.com/help/roomba