Well I have joined the club too, failed 😞
I attempted yesterday and surprisingly, I received the exact same result as yours, below proficient in 4 and near proficient in 2. I passed my CISSP last year, and soon after that I started preparing for CCSP, even though I had been a little on and off in my preparations, but I did cover a lot and that includes the below;
1. ISC official Study Guide (Cover to Cover 2 times)
2. ISC CCSP CBK -2nd edition (Cover to Cover)
3. Various NIST Publishing (skimmed through 800-37, 800-40, 800-53, 800-145, 800-146)
4. Watched Adam Gordons videos, 2016 from ITProTV (35hours+)
5. CSK Security Guidance v4.0 (Quick Overview)
6. Over 4000+ Questionnaire from various sources including ISC Office Practice Test
Even after then and after failing the exam, I can comfortably say that my preparation was not enough as per the exam standards, because official study guide and the preparation materials and preparation questionnaire covers only the concepts of the topics, whereas the exam requires deep down knowledge of every single domain and topics, and I also feel that once MUST have hands on experience in those domains to be able to answer, and yes a lot of questions were very confusing the way they were written and asked and unlike CISSP, where it was easy to cross-out 2 wrongs out of 4, in this exam all seems to be very close match, specially when considering the questions carefully.
To validate and certify my knowledge I would be attempting CCSK exam next instead of going for 2nd attempt for CCSP. Wish me luck!
P.S. I do have one regret, that I was not able to get hold of 2nd Edition of ISC Official Study guide, I hope there is not much of difference.
What I found on my CCSP training course was that unless delegates had actually been involved in procuring colo space or building a data centre facility then they found some of the material difficult to relate to. The CCSP seems to assume pre-existing knowledge, which isn't in the books.
Good luck with the CCSK! I did read the ISC Official Study Guide 2nd edition cover to back, twice. Highlighted many areas for reference and referral. Not much difference.
Just reading the CBK and doing the official practice tests is not enough to pass any exam in my opinion.
I have read extra materials like ISO standards, NIST, OWASP, CSA, OWASP, Enisa etc. Also I have been involved in cloud projects where architecture and technical implementations were part of it.
I came across more technical architecture and implementation related exam questions than I was expecting.
I suggest to do CSA CCSK (includes CCM) first (materials are free to download), read the CCSP CBK and search for extra materials you are not so familiar with and pay attention to implementation best practices. AWS and Azure have some good online materials and also CIS benchmarks could be helpful.