Decoherence of trapped-atom motional state superpositions