No doubt.
I view a dragon like I would in the real world of an Apache attack helicopter or a Harrier jump jet.
There's no way one is going to take them down with hand guns, they'll just swoop in and the person dies.
If you were being objective, you would understand that. Dragons really are that big of a threat (based on their abilities). The fact that the module did not emphasis that means that the designers were playing "Combat as Sport". As a player, I do not know that.
I just know that I was given a situation which seems like a death trap and my first reaction is to talk it over with my fellow players.
I am not roleplaying a regular person. Regular people end up on the Darwin Awards list. I am roleplaying an adventurer with an Int of 16. Someone who weighs the risk with the gain and someone who is trained to know that just rushing in is the fastest way to die. Btw, if the NYC authorities would have had a good idea that the WTC buildings were about to collapse, they would have ordered their men to not enter them / get out of them. It happens all of the time with fire and police. If the risk is too great, they stand down. Same with our troops. They do not just recklessly rush into battle. Knowledge is the key to good decision making and there are rules in place for fire, police, and soldiers to not make the same dumb mistakes that were made in the past. If a plane ever crashes into another building in one of our cities, you can bet good money that the police and firemen will not go in unless they are disobeying orders.
Some people play lawful good as lawful stupid. I don't. There are times when a heroic PC should sacrifice himself, and other times when he should walk away and plan to fight on more equal footing.
The fact that you appear to be arguing that PCs (regardless of whether they are heroic or not) should just rush in without any thought is a bit strange.
I totally get that your group jumped on the "I'm a hero" bandwagon and rushed in (or snuck in) to save the day. That's cool.

Not all tables are like that. A dragon is a big enough threat that it should give all PCs pause, and the game designers should have emphasized that. They didn't. That's so weird. The fact that a lot of people ignored how really serious a threat a dragon is is even weirder. People have played the game for decades and do not understand how deadly a DRAGON!!! is? WT?
I can only surmise that some people who cavalierly went to the town and did not really discuss the dragon metagamed that it was an adventure, so they were supposed to head in. Like in the Mearls video where the players barely discussed the dragon.