remote_src and template_host for template module not working for me

You can’t, template will only work with a source on the controller as that is where the cars are stored. Either store the template in your role/playbook or use fetch to fetch the file to the controller temporarily and then template it from there.