Sure, why not? Why, what sword do you normally use to fight dragons in your day-to-day life?
Seriously though, a rapier was added so that people could live out their 3 Musketeers/Inigo Montoya/Zorro (maybe Puss in Boots? now also Lara Raith?) fantasies. ... Just like every other fantasy trope...