You do occasionally see flaccid cocks in media and IRL, but only from guys confident enough to show it in the first place, which skews public perception a fair bit.

I went to school with a girl who’d only ever seen erections drawn. To her first boyfriend, she said “is that it?” the first time she saw a boner. It was a perfectly average cock, but she’d been expecting something the size of a cucumber