CNAME is basically used as an Alias for other domains,
It won't redirect the users or bots to that domain, it will resolve the subdomain to the targetted domain IP address ("A" record),
For example, if set a CNAME record pointing to "google.com",
That specific subdomain will show the content of "google.com", including all of the HTML source code,
Most websites & web servers won't allow the content to be shown anyway, so it will result in a "restriction" type of page(s),
And even if the website (or you configure your own website) shows the content, it will be the content of the main domain/website,
It's pretty much as if you're copying all of the domain content and showing it on your own subdomain,
SEO-Wise, it's something to avoid, it's pretty much useless,
Just add a redirect from the subdomain to the main domain if it makes sense,
Make it page to page if it's possible, redirecting every page to a topic-relevant one