When it comes to Super Bowl ads, the use of well-known songs can be a high-risk, high-reward proposition, an industry expert says.