Pronounced AM as in I am, and brose like Rose with a b in front.
I knew a schoolboy whose nn was Ambrose. He accepted it readily and nobody found it amusing - it just seemed to suit him. I find it a bit too ecclesiastical for comfort, but others would see it differently.