How many miles on your X? Not quite sure it is a tranny related issue. Could be a metal part loose in your cat convertor. The sound could disappear as you rev the engine which would explain why you do not notice it when using manual as you may rev the engine more than on automatic.
Just my 2cents