I had 10 storeviews in mi Magento 2.3.5-p1 installation
I removed 4 storeviews and ran a bin/magento indexer:reindex after that
but i still can see all the storeview tables in the db full populated as:
catalog_product_flat_x
catalog_category_product_index_storex
catalog_category_flat_store_x
Is that normal?