Fix pipeline status for transition between stages

What does this MR do?

This MR fixes pipeline status calculated when there is a transition between stages - one stage is completed but processing pipeline worker still did not enqueue the next stage.

Does this MR meet the acceptance criteria?

• Changelog entry added, if necessary
• Tests added for this feature/bug

What are the relevant issue numbers?

Closes #29699 (closed)