Both Lemmy and Piefed support it, though weirdly unlike the alt text field when submitting an image post, this syntax only adds alt text, so only screen readers will see it—users can’t view the text on hover.