It shouldn't really because 'snakes' is a countable noun, but in every day spoken English you're less likely to hear 'the only thingS I'm afraid of ARE snakes'. In this case the word 'snakes' is being used as a singular, so yeah you're good. It's a natural sounding sentence.