A video shows the partial collapse of a West Midlands bridge, which has left residents with a 12-mile round trip to the shops.