When Automation Fails: The Cost of Fragile Tests