The -mb- combination (there's another one!) also occurs in names like Bimbo and
Bambi, which are specifically used (and invented?) for animals. Rambo seems appropriately violent: ramming something or someone, and the image is of a horned animal in a very bad temper.