You don’t know how YOU will be either. Even though this is 2nd baby you’re 10 years older and people don’t always have births the same as with previous dc.
You could go 2 weeks over due date estimate and so baby will only be a week old, potentially you could still be in hospital nye, especially if like me and many others you end up having a c-section.
Even if you give birth on time, relatively smoothly and you and baby physically/medically ok you’ll more than likely still be knackered, bleeding, sore... if you’re bf it’s unlikely you’ll have that established and be completely comfortable with it and even if you’re not you may still be lactating.
...and that is before you consider the fact that nye in most towns is a pretty lairy, loud, drunken and very unpredictable night.
I absolutely would not risk taking a newborn out on that night into a restaurant or similar.
Does the friend have dc? Sounds like not and so they have no idea what it’s like to be post-partum and caring for a newborn
At 3 weeks after I’d had dd we’d only been home from hospital 11 days, I was still very sore from c-section, bleeding, knackered, bruised, legs very wobbly, struggling to establish bf as dd had needed to be tube fed initially. Dd was feeding every 1-2 hours, very clingy, hated being put down and needing nappy changed at least as often as being fed.
And I’m a poster that generally thinks babies are very portable and adaptable, usually taking babies to restaurants, weddings etc not a problem but no not nye.
Even just going out yourself if you’ve had a section you’ll be VERY wary of people bumping into you or pushing you aside.