A credit ratings giant has reprimanded Australian states as the dramatic consequences for reckless spending are revealed.