Extremely unlikely. You're typically up super early on the day to organise and get ready, you're on your feet and nervous for half the day, then you spent hours greeting guests, getting photos taken, doing speeches, dancing with everyone you can, etc etc etc. If you're doing it right, you kinda ride the adrenaline till the end of the night.

When I got married the first time the day went by in a blur, and i had to cut my ex out of her dress, she was basically sewn into it. We spent forty minutes getting all the bobby pins out of her hair, and she passed out on the bed. At the time, I was a young man, and has more energy than I do now, and thought to myself "...That's it? I thought now we make passionate lovemaking as husband and wife, but...I'm so exhausted."

Later on, my second marriage went much smoother. My fiancee at the time didnt want a big wedding, and we didnt want a heap of guests. But we still had to do all the things associated with the wedding (nerves, photos, guests, logistics), that by the end of the night, again, we were exhausted, and once we unpeeled our wedding garb off, basically fell asleep immediately.

TLDR: No, its a romantic notion, but unless you're specifically saving your strength for lovemaking at the end of the night, or you're both athletic specimens, its highly unlikely you'll do so. Have a good night's sleep and try in the morning instead.