Is the word foggy a double consonant word?

No, "foggy" is not a double consonant word.

A double consonant word has two consecutive consonants in the middle of the word.

"Foggy" only has one consonant "g" in the middle.