When removing a store to a product. The data of that product store view are not deleted in these tables. I'm not yet sure why.
You may encounter issues like when filtering in product grid.
In our case. set filter status = 'Enabled'. but you will see some rows that have status = 'disabled'. the reason is, it is enabled to the store you deleted which needs to be cleanup. "Magento 2.3.4"
This is where this command comes in:
php bin/magento catalog:product:attributes:clean
This will clean the tables. So that grid filter will work as expected.
I think grid filter will not only be the issue, I hope this gives some idea.