Many times overbooking works just fine. Usually, the number of no-shows is equal to or more than the number of overbooked passengers, everyone get a seat.
Unfortunately, sometimes the number of no-shows is less than the number of overbooked passengers, There are not enough seats for passengers, resulting in the flight being oversold