Improves tempest table creation and deletion waiting mechanism

Due to new table states we can improve tempest table state waiting
mechanism in cases of creation/deletion failure.

Implements bp: tempest-table-waiting-improvement
Change-Id: Id06dcaa8103b3337e69f8743b8adea550db24bd2