Exchanging one point of failure for a fleet of more expensive managed points of failure.
And I would assume a CDN is more reliable than you personal webserver. That's literally their job.
CDNs are not by definition "more reliable" than a single webserver, especially one with little traffic. If DDOS is your problem, you need proxies, not plain CDNs.
Plus you're probably going to use lots of different CDNs, because all of that of that static content is from different sources and it's "best practice" to get it from there, or maybe your SaaS forces you to use theirs.