DNS question

For your purposes, the CNAME records are just a pointer in the DNS lookup. The browser doesn’t follow CNAME redirections.

In either case, you would need to configure a web server for example.com to send a redirect to community.example.com.