After two-and-a-half years wait, Mariah Carey will finally be inducted into the Songwriters Hall of Fame