I’m never sure how much Q magic happens to erase the crews memories.

They always return to only a few bridge officers remember the whole thing.

Actually, in hindsight that would be so depressing to find out the Q with their omnipotence and probably future sight found you so uninteresting as to write your mind, but not the guys you work with