This change restructures the tasks_with_status view query to:

• Improve debuggability by adding a status_debug column to better understand the outcome
• Reduce clutter from bool_or, bool_and which are aggregate functions that did not actually have serve a purpose (each join is 0-1 rows)
• Improve agent lifecycle state coverage, start_timeout and start_error were omitted
  • These states are easy to trigger even in a perfectly functioning workspace/task so we now rely on app health to report whether or not there was an issue
• Agent stop states were implicitly unknown, now there are explicit (I initially considered error, could go either way)