Multi-layered absorbent composites having one or more apertured transfer layers