On the prevalence of radio-loud AGN in brightest cluster galaxies: implications for AGN heating of cooling flows