by october , this ineptitude culminated in lord cardigan 's charge of the light brigade , a spectacular feat of heroism which decimated three-quarters of his forces in a successful effort to capture the wrong battery of enemy guns .