Yes, this is a frequent issue.
I was once on Zolpidem and after only a few uses it was like it did nothing.

The first time was when it hit me like a storm. I couldn't believe how drowsy it made me. Then it got ineffective rather quickly.

Another hypnotic can be tried- zopiclone, zaleplon etc. but is likely going to have the same thing happen,

A low dosage of a neuroleptic may be prescribed because of the sedative effect it has.