Reclaim disk space after drop table from database in mysql
You need to "reorganize/rebuild" the table truncated  which can be achieved by below.

mysql> OPTIMIZE table table_name;


for InnoDB tables, it run under ALTER operation.

reference: https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html