Cloudflare isn't too much more than a wrapper around a CDN for your static assets. The request still gets sent to your server, they just re-host your images and stuff on their edge servers. They also do some "security stuff", and can help you with minifying assets and things like that. So excessive load can still be a problem.

On top of that, the free account doesn't really come with any guarantees.