Our tank is in the room next to the bedroom. Many times the pistol's pop has woken me up.
As for messing up the sand, ours digs under the rocks and has made burrows from one end of the tank to the other. Beware of this when thinking about adding a pistol to an already established tank, especially if you put your rocks on top of the sand and not on the glass bottom!!