When deleting a site within a Multisite with wp site delete <id> custom tables within the DB created by plugins remain within the database.

Possible solutions:

• Add a flag to remove all tables with the sites prefix wp_<id>_ using SQL
• Remove all tables with the site prefix by default

WP-CLI 2.8.1
WP 6.3.1