You must remove the redirect from http to https before generating the Auto ssl, then you could place it again
Thanks @josemnunez, that was the issue.
For any one coming here or future me.
If wordpress is hosted on HTTPS first and then moved to CWP. need to change `siteurl` and `home` values to be without https in `wp_options` table. This will stop the redirect to https. Then generate the certificate.
It does solve my problem