Yes. And for sure if that's what I already had.
Once your moving, there's no difference with the manual. That truck is made to tow. You'll probably get better fuel economy with a stick too. Although I'm pretty sure that V10 is going to drink a lot of fuel.
Replacing it would depend more on your use of the TV. My truck is also my daily driver.
If all you're going to do with the truck is tow the airstream, and you're not a full-timer, I'd spend your money elsewhere.
1996 Airstream Excella 28'
2007 GMC Duramax 4x4 CCSB