Not smart is a passive act, remedied with learning, experience and thought.
Stupid is active, the work of someone who should have or could have known better and decided to do something selfish, impulsive or dangerous anyway.
The more experience, assets and privilege we have, the less excusable it is to do stupid things. And at the same time, the more useful it is to announce that we’re not smart (yet).