Dave,
I cannot think of a defensive battle where Wellington had any significant heavy cavalry force to hand to compare Waterloo with, but, yes that must have been their intended role. Yet at the time of their charge, Picton's advance had checked the French, initially, at any rate. How long he could have held them is another question ?
Paul