Please see the Popular Questions FAQ and the /r/Linguistics FAQ here
The short answer is that it didn't die out, it evolved into several languages called the Romance languages, such as Spanish, French, Italian, and Romanian.