The acid flavour will settle once it's in the jar. I think some recipes are just too sweet, I got caught out a few times and have decided to just use less sugar because it's easy enough to dissolve some in later.

To fix this batch, maybe try more pepper or chilli to add another flavour dimension other than sweet???