How quickly did Latin fall out of fashion?

Obviously people didn’t immediately stop speaking Latin once Rome fell, but when did Latin truly become a “dead” language? Was it something gradual that took centuries or was it over in decades? And if it did take a while, were there “intermediate languages” as people transitioned to the Romance languages?