"Did" refers to a specific time in the past, whereas "Have" does not. For example,
Specfic: The "When" is known to the speaker
Did you experience any embarrassing moments yesterday at the meeting?
Non-Specific: The "When" is unknown to the speaker
Have you ever experienced any embarrassing moments in your life?