Create recovery opportunity for failed subscription payments in pipeline

Failed subscription payments arrive without account updates, delaying collections and hiding churn signals. Log failures into recovery opportunities so billing and campaign managers can start outreach same day.