It's up to you.

Sure beats what’s there now! try to see if it’s available in 24”. 18 migh be small for the space

I actually like the current one more.

Thanks groveraxle for the picture. New light doesn't have much impact on space. Wow factor isn't there. Original light is actually broken so I must replace. Any suggestions from anyone about new lighting? Looking for light from nearby stores... home Depot, Lowe's so I can return if problems.

Not sure about that one either, but the larger size does look better.

It's important to remember that just anything else, a chandelier should represent your own personal style. Don't get caught up in playing by the rules. Pick something that can enhance your space and works with the way you actually live. To size a chandelier for your dining room, or to be the focal point of your space, measure the length and width of the room and add these figures together. The sum, converted to inches, will equal the diameter that you can as a guideline when selecting the size of your chandelier. If the resulting measurements (room length + width converted to inches) seems inappropriate due to the size of your table, size your chandelier three quarters the width of your table. Remember in most cases , the bottom of your chandelier should sit approximately 30"-32" above the table top.

https://www.homedepot.com/p/Feiss-Adan-6-Light-Rustic-Iron-Burnished-Wood-Chandelier-F2749-6RI-BWD/205882689

Maybe split the difference between your choice and the drum?

I like something in this genre (linear but petite).

Something with more pattern will be more impactful. But don't get caught up with the pendant. The space is really large and you can also consider hanging an art piece on the wall behind. It could be a game changer.