The well-used bridge connects two villages over the River Trent