You don't need to remove the tables, but if you do, they will be recreated when you enter the admin page for nukeSEO.
You should check with your host to resolve the issue with temporary tables. The next version may not have temp tables - to prevent this very issue.
_________________