Additional exception handing for NTD API operator

[charlie-costanzo]

Following up on #3467 and #3472, because we wanted to get MVP tables into the warehouse, we are returning to add Exception handling for any non-200 response from the API (e.g., a 404 response will still return some JSON, but not in the structure that's valid for the table).

As captured in this PR comment

Also if desired: Add handling for prepending test to bucket names in local airflow runs