Epoxy seems too thin to me and would just leak everywhere. I would have tried some expanding foam. It’s pretty cheap, you could put the rod in while it’s still setting, and the extra that flows out of the hole could be cut off easily to be flush with the wall. In my experience it’s thick enough that it wouldn’t all flow out before setting too