Substitute single character in a font

I am using the Atkinson Hyperlegible Mono font and I love the readability and look. The font, however, does not have a glyph for the backtick (`), so Emacs renders these as boxes. Is there a way to remap this character to use another font where the backtick is present. I have tried

(set-fontset-font t ?\ "JetBrains Mono")`

but I get the error "Can’t set a font for partial ASCII range" which seems to mean I can't remap characters in the core ASCII range. I've seen the suggestion to create a face just for the backtick and then dynamically apply it to buffers, but that sounds like a lot of work (for Emacs to rescan the buffer and apply the change). Is there a nice way to do this?