It's also very, very easy to miss a connector flight if the plane coming in is delayed, or even if the airline decides to route you through an entirely different city. I've missed a couple that way. You can get held up at customs or security when landing in a new country and that country requires everyone to go through customs and security again.
Then there is illness, accidents, and emergencies that come up all the time.
You also have people oversleeping, getting caught in traffic, getting confused about their flight time. It happens. I've missed a few flights in my life for these reasons. (But just a few.)
Finally, business travelers do make last minute cancelations and changes on a pretty regular basis--for example, to get on an earlier flight out.
Yes. Wendover Productions on YouTube posted an excellent video a while back explaining why airlines overbook their flights: https://www.youtube.com/watch?v=EqWksuyry5w Most of the time it's not an issue.
As someone that's never flown it's surprising to me that overbooking is even a thing airlines do, who's out there missing their flights? I can't even imagine cancelling a pre-booked taxi never mind a flight!