I am still getting familiar to Dropship rules and I understood that if a Light Vehicle bay carries one vehicle up to 50ton and a Heavy Vehicle bay carries one vehicle up to 100tons.
If my understanding is correct what is the point to transport smaller vehicles and not maximize the available space?
The point is that if you have a lance of Vedettes or Condors, you can bring them. If you have a lance of Scorpions or J. Edgars instead, then you bring those. Either will fit, regardless of whether you're "maxing your tonnage" or not. An attacking force should try to utilize the available tonnage, provided that doing so doesn't compromise the mission profile (such as bringing a lance of 3/5 Assaults on a raid where speed is critical), but it doesn't have to. You can bring additional tonnage as cargo, if necessary, which only pays for its actual tonnage, although it will take far longer to unload and/or re-load.
The game being a FASA creation, it does not necessarily make sense, so rather than seeing a large concentration of vehicle designs at 50 tons, which one might expect as a result of the transportation limitations, we have a plethora of lighter vehicles, and several more in the "slightly bigger than will fit in a light vehilce bay" category.