The Corvette transmission is a rear mount transmission. It won't fit in the Kappa all that well (if at all).
Not sure why you would want it with the 2.4L anyway. It is really just a 5 speed transmission with a second overdrive gear to help it achieve decent highway fuel mileage and avoid a gas guzzler tax. It doesn't have 6 speeds for performance reasons.
Besides, I don't think this car really needs a true 6 speed with the stock engine. It has a pretty flat power curve as it is, and I would think that adding an extra shift would cost you more time to shift then it would gain you in keeping the revs up a little more.
__________________
We Build Excitement