[storages] Enable s3-auto-delete option by default

This option is misleading as one would expect S3Storage to enable
deletion by default.
4 jobs for topic/default/delete-s3-auto-delete in 2 minutes and 33 seconds (queued for 19 seconds)
Status Name Job ID Coverage
  Test
passed check_manifest #109883

00:00:33

passed flake8 #109884

00:00:31

passed py27 #109885

00:01:54

passed py3 #109886

00:02:32