I think we are talking about 2 words with different meaning and pronunciation.
Stingy - unwilling to share is pronounced with ‘ j’ in British and American English.
Stingy derived from a sting / stinger ( a part of an insect that stings you) is pronounced with hard ‘ g’. It means able to sting, stinging.
Stinging is more frequently used , a stinging insect or pain. But you can still see ‘stingy’ being used.
I hope it clarifies the confusion :)