InnoDB disk usage overhead
This is because the index you created takes up space as well. In the case of a clustered index in InnoDB, the row data is actually stored inside the index leaf nodes, so when the index is used the index does not point to the row but instead points to the index leaf node that contains the row data along with the PKEY.
This caused the storage to be much larger.