I would suggest playing around with your zones, move them without hesitation then sit in each space and rule them out or in as you go.
Fresh eyes and all that.
I would move your dining to your current lounge, the lounge int that alcove where your study is, you window is higher in here and will accommodate that smart fabric sofa with the tv cabinet on the opposite wall, the armchair will fill the corner really well with a smart floor lamp to accentuate the window and views by night, it will easily become a cool place to retreat. Lounges are also nicer when they have some sense of detachment from the busy work zones ie kitchens and hallways.
Your study can be modernized and positioned where your current dining table is, because it's small, and would be an afterthought as you walk right past it from the corridor entering this space. Think stunning bookshelves. Some retro looks have floor to ceiling open backed shelves that could create a hall divider when coming in, so the kitchen is a little more separated, but also, the wall could have some smart practical joinery built here. I would put a desk along the short wall with a designer chair, maybe an upholstered one, a featherston or eames. This creative space could really sharpen the overall look in here, there are some amazing looking workspaces to be inspired by, and the new lounge would feel a real getaway tucked into your corner. You simply go there to relax and Wong have people walking through or past you anymore.
The dining room will be where it naturally floes towards, although I love your furniture, id consider some eames or tolix replica chairs with this table as well.

Consider using your tv cabinet elsewhere maybe a bedroom, as the tv mounted on the wall will give you more space from the sofa also. It's not ideal as it is a close space,but currently your sofa doesn't even face the screen which must give you a crook neck.
You all must fight for that foxy red chair!
I wonder if that white cabinet fits on your dining wall, because if it did, I would get a solid timber desktop from ikea and secure it out from where the tv sits to create the desktop, that way you have built in storage and workspace with room for a nice chair on both sides of the desk. Shared workspace, and room for tour artwork on the back wall.

Thanks for some really interesting ideas midesign! Lots to think about. The current dining space could be a study area - it wasn't anything when previous owner had it, so needs to be designed carefully or it is lost as you walk through. Will keep thinking about it all.