Move UPSTREAM_FAILED to Terminal State and Add State Validation Tests

[seanghaeli]

Description

Move UPSTREAM_FAILED task instance state from intermediate to terminal state class and add tests to validate that state class relationships remain consistent (failed + success = terminal, terminal + intermediate = all task states). Motivated from #51719