[Question] Do we need a error status for the subgraph? currently it doesn't have.

f a user has a workflow with nested subgraphs, and the subgraph inside the subgraph has errors, I think it might be hard to debug sometimes.

https://github.com/user-attachments/assets/fa2a8a78-8e50-453b-b9ec-3f4730a1fef3

┆Issue is synchronized with this [Notion page](https://www.notion.so/Issue-4621-Question-Do-we-need-a-error-status-for-the-subgraph-currently-it-doesn-t-have-2416d73d36508137b943f4dab3d73924) by [Unito](https://www.unito.io)