Logically, I suppose it should be "hornets' nest" with the apostrophe after the "s", but for some reason "hornet's nest" is slightly more common. Both are frequently used, however.

Yes, that is correct.