I've heard it's technically possible with the protocol, but the way it's typically implemented prevents use with static sites. I'm not sure of the details. I would like to see all the major AP implementations add support for following RSS feeds. That might even be a better way to do it.

I'm not familiar enough with the intricacies of your case, but it certainly is possible.

E.g. https://github.com/ufosc/TheIsolator is a way to publish your static site updates, on deploy, to your AP followers. I've seen similar tools/attempts for Hugo and Cobalt.

I came here looking for a way to do exactly this, but it looks like Thelsolator is unfinished with the Go code only printing "Hello World!"

Are you referring to https://codeberg.org/jlelse/hugo-activitystreams for "Go"? Description here: https://jlelse.blog/dev/activitystreams-hugo/.

I have no experience with this but I have experimented with TheIsolator for my jekyll blog. Its simplicity appeals to me.

There exist RSS-to-ActivityPub services that solve this issue.