Cloudflare is the first step to be protected against DDoS, but with free plans, it require to use a special page during 5 seconds to check your browser and make sure you are real visitor, and it doesn't protect your server, only your domains with the Cloudflare Proxy.
If an attacker find your server IP, he will be able to DDoS it and Cloudflare will be useless.
DDoS attacks will not stop in the next few years, the last one against OVH with up to 1TBps is the proof DDoS is still used and it's easier to DDoS now using any device connected to internet.
But that's the job of Hosting Providers to fight against DDoS, Cloudflare will help them, because they do a very good job with their DNS service, but they still have a small network compare to company like OVH (7TB Bandwidth and 5TB Exta for DDoS)