improvement(mothership): improve streaming state transitions #15981

Job	Run time
Detect Version	4s
Test and Build	0s
Check Docs Changes	0s
Build Dev ECR (./docker/db.Dockerfile, ECR_MIGRATIONS)	29s
Build Dev ECR (./docker/realtime.Dockerfile, ECR_REALTIME)	31s
Build Dev ECR (./docker/app.Dockerfile, ECR_APP)	3m 7s
Build ARM64 (GHCR Only)	0s
Process Docs	0s
Build AMD64	0s
Create GHCR Manifests	0s
Create GitHub Release	0s
Migrate Dev DB / Apply Database Migrations	37s
	4m 48s

Provide feedback