Yes. While normal types are immune to ghost type moves, non damaging moves that cause secondary status effects like confusion still have an effect on them.

Is supersonic or confuse ray better?

Confuse Ray has only half as many PP as Supersonic, but, as noted above, it is clearly superior to Supersonic. On top of (and, in fact, because of) its tangible effectiveness, Confuse Ray is one of the most unsettling attacks in the game, and therefore a great psychological weapon.

Is confuse Ray a good move?

#4 - Confuse Ray

Using a damaging attack that can confuse a Pokemon is great. Simply shooting a Confuse Ray at it, however, doesn't cut it. Confuse Ray takes a turn to confuse the opponent, which in the games is terribly random.