How do you detect when the player stops colliding with an object?

You can add a sphere collision to your character and make use of it event BeginOverlap to trigger a sound effect.