I guess that’s the whole point why most people tend to build some kind of relationship before jumping into bed. It’s not weird if there is trust and affection between the people involved. It’s also a basic instinct of most animals, it’s something you want so any awkwardness that may arise is secondary.
I don’t think that has anything to do with having sex.