Hypnosis works. A more accurate way to look at it is that hypnosis works most of the time for most people. It is not some perfect miracle. Therefore, there bound to be people who do not find hypnosis work for them.
As in anything, some people will not be able to positively react to certain medication, certain doctor, certain environment, certain therapy method etc.
The key is to find out what is working FOR you and benefiting you, then continue using it.