Originally, this was something males said to alert each other of an attractive female. Now it is more commonly used to simply make a phrase sexual. As a result, the phrase "bow chicka bow wow" has come into usage to refer to something sexual, whether explicit or implied. It is also used as a euphemism for sexual activities.
Man to friend as girl walks by "Bow chicka bow wow!"
Massive Wirral explosion
21 hours ago