Hmm, Tooltip CK is actually very close, with some custom CSS to style it more like a text highlight.
Unlike other Tooltip plugins, it allows you to edit Tooltip text inline (rather than treating it like a glossary with another content type). Unlike most footnote plugins, it doesn’t appear at the bottom or use superscript. Unlike most annotation plugins, it doesn’t require a third-party service or assume community editing.