exp show: sync state between queue and exp show table

[dberenbaum]

Suggestion from @mattseddon is to use the State column with something like 'Starting'. @pmrowla Thoughts?

Yes we can do this, but it will require some work on the core DVC side. Basically the issue is that the state column in exp show is still using pre-dvc queue hacks to determine what is running.

IMO what we ideally should be doing is figuring out how to properly handle the separation between "collecting git-committed experiment data/params/metrics" and "queue/task execution state", but if we need to continue shoving everything into exp show in the meantime we can still do that

Originally posted by @pmrowla in https://github.com/iterative/vscode-dvc/issues/1995#issuecomment-1203567280

[dberenbaum]

From https://github.com/iterative/dvc.org/pull/3715 and other discussions, it's clear that there is separation between these concepts, but it's easier for users to see them both at once in a lot of cases. Otherwise, it becomes hard to connect the queue task info to the experiment info. We can also mock up or try out different formats here and see what works best.