Interestingly, I've found it super valuable when learning music by ear, especially given that I find myself able to slow down the "replay" of the sounds to better hear the individual notes, although it is also mildly entertaining to be able to hear a long sequence of sounds (e.g a car outside my window beeping repeatedly) and slow it down in my head to count the number of individual beeps.
But I don't have 'playback' memory for anything else, definitely not for visuals or touch. So if something is said around me and I didn't listen, I can replay the last couple of seconds or so, and that's usually enough. Helps with languages you're not fluent in too. But if I suddenly notice that I'm now touching something that I shouldn't, say, for example with my arm, in a crowded pub, there's just no way I can 'replay' history, not even the last moments, to figure out how that happened. Unless I actually paid attention when it happened. Same with visuals. If I didn't recognize what passed before my eyes there's no way to replay that to take a better look. Unlike with audio, where I can do precisely that.
My favorite thing about sound memory is echoic memory[1], a very specific type of memory that is basically like a buffer or a cache. Basically perfect audio memory of the last few seconds. You can replay the sound in your mind and analyze it for that brief moment in time.
I speculate that this is almost entirely to help you properly react to things that woke you up. You were sleeping, now you are awake. But why? You still hear the sound in your head, was it something falling, or a glass window breaking, or your dog barking, or a gunshot, or just thunder? It could be very important to know.
[1] https://en.wikipedia.org/wiki/Echoic_memory