So, honestly, I don't think it would be wrong for the company, if they knew about the automation, to let the OP go and have the analysts themselves run the script. As a company, I don't think you should be required to pay someone to do a job that isn't necessary, even if the worker himself made the job unnecessary. I mean, we wouldn't be having the same discussion here if the company had instead hired someone (perhaps even the OP) on contract specifically to automate the job, and that was it.
I hesitate to suggest that what the OP is doing is unethical. I think aspects of it aren't quite above board: deliberately inserting bugs/mistakes to hide that it's now automated is, IMO, crossing the line. And at the end of the day, the company thinks they are paying the guy to do one thing, which they believe takes a significant chunk of time, but that's not the case. If he wasn't remote, and had to come into the office every day, his deception would probably be quickly found out, so in essence he's abusing his remote-work arrangement.
But hey, you gotta eat, and 1:1 time with a child is a great thing. Employers naturally have the advantage of a power imbalance, and it sounds like this guy lives in an area where tech jobs aren't aplenty.
I think my advice would be: well, the deed is done. Don't tell your employer yet, but start using your copious amounts of free time to search for a new job that also allows remote work, even if it takes several months to find one. Once you find something, give notice, and tell the employer that, as a parting gift, you automated the job, and give them the automation tool. At that point it's up to them what they want to do: hire another data entry monkey, or use the tool. Either way, I doubt this job would last forever (automated or otherwise), and then you'd just be out on your ass without any professional growth on record to use to help you get a new, better one.