No it's not. The head very much isn't supposed to pull down, or get tugged on, when the foreskin goes back.
It's either loose enough so that the foreskin can glide back, without pulling, or it isn't and things get pulled on uncomfortably.
Some men have a frenulum that's so thick, and strong, that it doesn't hurt them at all when tugging on the glans. Most frenulum are relatively thin and fragile though and all you get are winces of pain if it's pulled on too much by accident.
I'm speaking here from experience of playing with lots of dicks and having talked about this with guys. The general consensus is that a good frenulum is one that's loose enough to enable the foreskin to go back completely, without any, tugging on the glans or, bunching up of folds of skin.
Now it is true that some men do get pleasure from the tugging action but this is almost always accompanied by some pain during penetration when things get yanked too hard. And things do typically get yanked on too hard. Lots of guys end up tearing theirs.