Delete removed tables from public facing datasets

[scholtzan]

See https://mozilla.slack.com/archives/C01E8GDG80N/p1758128461609629

We had a case where someone accidentally created a table in a user-facing dataset and later removed it in bigquery-etl after the table already got deployed. We do have a process in place to delete views (./bqetl view clean) whose definition got removed. We should consider putting something similar in place for these cases.

Additionally, a CI check could have prevented this, if we were to strictly enforcing only having view.sql files in public-facing directories.

┆Issue is synchronized with this Jira Task