Shield wall improves the defensive ability of an unit but slowes it down. It is quite usefull if you want to defend a position without moving your troops around. Even light spearmen like levies are capable of stopping a cavalry charge when in shield wall formation. Obviously, it's less usefull if you want to attack. However, even then I've used it with levy spearmen.