Even with erections during the night, during the day, you are walking, moving, using the restroom, adjusting, etc. - all things that are far more likely to wipe that off than a few erections during the night.
If you are gently rubbing it in as the directions state, you shouldn't have any issues with it wiping off.