Metabolic switching promotes microbial coexistence under fluctuating resources