Unravelling sediment transport driven by a multimodal wind-wave spectrum