Will a lower cold cranking amp on a car battery affect the idle speed rpm Mazda 2.0 sport 2007?

No. Battery cranking amperage has nothing to do with engine idling. There are a lot of potential issues from vacuum issues to ignition.