Senedd members warned schools face “harrowing” funding pressures that risk failing a generation of children and young people in Wales.