Same as above:
Can I create a CNAME record to point a subdomain to a webpage e.g. blog.example.com -> example.com/blog?
I would also like to know if I can do this to point subdomains to webpages on different websites.
e.g. bluesky.example.com -> bsky.app/profile/example.com
No, when you make a http request, the route is a part of the headers. DNS is only the name part.