What happens when the person created Automation left and user disabled?

Two choices.

1. Use a robot type userid (ie not a real person), owned by the IT dept that will love forever.  
2. When someone leaves, yes, remember to touch every Automation they own to make a trivial edit to the description to change the ownership.

I encourage my clients to use Option 1 since if the real user loses access, the automation will fail.