I think they work. We have the top one in a smaller size and you do realize it uses only 1 bulb? I think I would prefer more light over my dining table.

For me - on my screen - the finished do not work together.
The styles are fine together.

I know-I wish I could find some aged brass or oxidized brass sconces.

It’s very possible that those can work together. You do not have to be matchy matchy with your metals. It might also depend on how far from each other the fixtures are going to be placed.

Here are a few additional possibilities:

One bulb, with 100w equivalent all shining down will give off so much light, not sure what bulb the other user has but you can put a very high wattage LED in that fixture... looks like she might be using an Edison bulb which would be the equivalent of a candle, but probably a nice glow at night outdoors. Yes they work together. you could also look at Hudson valley, Hubbarton Forge, House of Troy

https://www.hvlgroup.com/Product/B7032

https://www.hvlgroup.com/Product/2101-AGB

You might try a light like this over the dining room table and then you could use the sconces you have posted or something similar:

Modern Ranch: Dining Room · More Info