Page 182 of this excerpt from Acemoglu's Economic Growth discusses aggregation and the possibility of a representative household. http://users.econ.umn.edu/~guvenen/DaronBook1.pdf
Aggregation of firms (and production functions) works quite nicely theoretically. Unfortunately, the same is not true for household / demand aggregation. The Debreu-Mantel-Sonnenschein Theorem aka. the "anything-goes" theorem gives a stark negative result. Utility functions are just too idiosyncratic to aggregate in every possible case.
However macroeconomists still do this for purposes of tractability. We know that sometimes aggregation is possible, if utility functions take certain forms. This is only one of many dimensions modern macroeconomic models are far from realistic. This is no secret to anyone.
Supply and demand curves are such an unsalvagable mess, in my opinion. Economists should just stop drawing them.
I just did a quick calculation - based on your suggestion - with linear demand/supply curves and what I got as the aggregate price is a weird combination of the two prices. It's not any kind of (weighted) average of the two, as far I can tell. In particular, it seems to me that the aggregate price will differ if, for one of the markets, we change either demand curve or supply curve but keep their intersection at the same point. That's wildly counter-intuitive, I don't know why should aggregate price behave this way.
Maybe I am wrong, and you can make it work. If you do, write it up! It really should be in textbooks, it's embarrassing they don't discuss this case.
And this is a case of two (presumably) completely independent markets with linear curves. It gets much more hazier when you have a relationship between the two markets (for example, one is a substitute for the other).
Disclaimer: I've never even taken Econ 101, so I might completely misunderstand something. If that's the case, please downvote and tell me where I'm wrong.
And I have never seen an economic textbook do that, either. But they all magically jump to aggregate demand and supply, where you have millions of products. They cannot even aggregate two!
Someone mentioned physics here. So that's what you do in physics, you analyze one thing first, then two things, then millions of things in aggregate. With supply and demand model, the 2nd step is simply not done, and for a good reason - the model will fall apart (as far as I can tell) at that point.