I would have been horrified if I had been in the supermarket with my grandchildren. It would also have offended me. I am sure most of the shoppers that day were offended too.
Did you know that it is an offence under the Summary Offences Act to use or display offensive language in a public place? The fine is not insignificant either.
I would also have asked to see the manager and informed him of his customer’s behaviour.