IMO a chandeier in a DR should light the table not the ceiling, it should also provide good lighting for the space . I think that fixture does neither and also too farmhouse for your table and chairs.I think something a little more formal looking would be my choice

Yup, what Patricia said. I would look at something with a little bling to it.

Its rustic/iron and your dining set is Georgian classic. Not a good mix.

https://www.houzz.com/products/24-brielle-polished-nickel-and-crystal-3-light-chandelier-prvw-vr~138114107

More like this >

Thank you! My husband wanted the light and I was thinking it was too rustic.

I think a linear light fixture would look better than round with this length of table.