I have never directly asked for an upgrade but normally introduce myself as an airline crew member to the purser. When doors are closed the purser (sometimes) comes along and has a quiet word....i.e offers and upgrade.
It's worked 4 times for me this year on long haul twice with BA and twice with my own airline.
I don't know if it would be available though with young children!
Best of luck with it!