Yes, but remember, the person doing the all night babysitting is most likely going to be up most / a lot of the night (hence the need for a night nanny), so if you look at in on an hourly rate, it's not that much.
I've only had a night nanny once, and she was brilliant - if you have the money, I can think of worse things to spend it on.