It's been about a decade since I played this so I could be wrong, but I'm pretty sure I remember some of the Aeons (Bahamut in particular) asking you to end the dream for them as they were tired of it. If I remember right the aeons were all part of that dream as well, so by them essentially asking for death it shows you at least some of them thought the same as Tidus. The sensor descriptions you can get from the aeons in your final fight with them pretty much confirms this as well. There's also this from the wikia:
http://finalfantasy.wikia.com/wiki/Fayth
After growing tired of a millennium of dreaming, the fayth request Tidus, a person who hails from Dream Zanarkand and thus a product of their dream, to destroy Yu Yevon so they can rest. Bahamut's fayth knows Tidus from his trips to Dream Zanarkand, and due to the fayth's shared consciousness acts as a spokesperson for all the fayth in asking him to kill Yu Yevon to stop the summoning.
So I'd say that's a pretty good indicator that almost nobody wanted the dream zanarkand to keep on existing anymore, its residents included.