If you set console-use-alternate-key=true you have to open console with 2 + ~ instead of just ~
Sadly, there's no way to configure key you want, so.. you can globaly\active for gta_sa remap ~ with some other key? That's 1 line in ahk script for example - https://autohotkey.com/docs/misc/Remap.htm