One Cardiff Council cabinet member said the parks would be protected for the 'long foreseeable future', despite concerns from opposition councillors about a new agreement