The 1990s saw big names like Shania Twain and Tim McGraw rise to fame in country music. But what about those stars who faded away?