What keeps the spinner nut on is you putting it on really tight.

I used one on my trainer and the starter would take it off sometimes, but it usually stayed on. And if it does come off, all you have to do it thread it on, tighten it down, and try again.

And you are right with using a crescent wrench or a small screwdriver to tighten it down. Either will work fine.