There is no single American pronunciation of these or of nearly any other English word.
What’s happening is Cambridge has chosen a written phonetic representation that fails to correspond to the pronunciation in their own sound clip. This is unfortunate. It is not true that 333 million Americans cannot pronounce /ɔ/ or /ɒ/, only /ɑ/. You can hear that the American sound clip they provide does not use /ɑ/.
The OED gives UK /ˈɔːɡəst/, US either /ˈɔɡəst/ or /ˈɑɡəst/. The first of those two is the more common pronunciation in North America, and does not differ substantially from the UK pronunciation.
The latter version with its unrounded vowel occurs only in speakers with the LOT–CLOTH split yielding unrounded LOT, the FATHER–BOTHER merger, and the version of the COT–CAUGHT merger that yields only the FATHER vowel, never the CLOTH or THOUGHT vowel.
Younger speakers from southern California may do this, and it is apparently those speakers’ speech that Cambridge chooses to represent in its notation. But their own sound clip belies that position.
See the Wikipedia article on Phonological history of English open back vowels.
You should also look at and listen to the many real pronunciations of daughter,
long, and
warm at the Sound Comparisons website. Do you see how much variation there is in the real world? A lot!
This should chase away any notion that there is ever just one possible exact pronunciation of English words, particularly those two that you mention here.