No, I don't think so. It was a long time in the planning and although there are some issues in some places, they'll hopefully address them rather than just chuck it out and start it again.
We tend not to get the same knee jerk reactions and changes in policy that England suffers from. Maybe because we don't have the swings in political dogma from Labour to Conservative that happens in Westminster.
It was the Labour/Lib Dem administration that started the change to CfE and the SNP Gov that implemented it.
As some else mentioned, Standard Grades "survived" for c20 years.
What does need to be addressed is the variations in the way it's been implemented. Ds' school is one of those that starts the Nat 5 courses at the end of S2, so they are still able to sit 8 Nat 5s. It did mean, however, that ds dropped the "expressive arts" in S2, when they're supposed to be included to the end of the "Broad General Education" which is supposed to be up until end of S3. (He'd have liked to do Art but the combination of Sciences and PE that he wanted to do had Art in all those columns so he ended up doing Computing Science as his 8th subject)
As a parent, I've not seen any issues with Maths - but that could be either or both due to the quality of teaching at ds' primary school (which had always taught in a CfE way) and/or 'cos ds is good at and loves Maths.
He's sitting his Nat 5 Maths in under 2 weeks and is confident of an A (top set). The class is already most of the way through the Higher curriculum and will apparently be starting the Advanced Higher curriculum in September.