The service behind the sub-domain which you’re using seems to be on a Cloudflare network, or already using Cloudflare, therefrom you should be able to use unproxied (DNS-only) for that particular CNAME sub-domain.
Looks like it’s working now, did you unproxy (DNS-only) as it’s stated in the below article? Could you confirm it’s working now?
From my understanding, you want to redirect users?
If so, you should have the DNS records as A type instead of CNAMEblog.lightscapeimagery.com pointed to the temporary IP address such as 192.0.2.1 proxied .
Then, using Redirect Rules, you can redirect your users to https://lightscapeblog.wpenginepowered.com/.
Otherwise, you want your Website visitors type blog.ligtscapeimagery.com and to see the content from https://lightscapeblog.wpenginepowered.com/ ?