Not sure if I've commented on this before but I'm pretty sure it's meant to be pronounced the French way of 'Bow'. That's the way I've always pronounced it at least. I know a Beau in real life and he is also with the 'now' pronunciation
Closer to "bow" (rhymes with "go"). I'm fairly certain it's a French name and that it should thus sound like the end of "gateaux," so that's how I pronounce it.