No judgement, but I feel like the Drake Sword is a pretty dumb weapon at the beginning of the game. It's way more useful to find a weapon with some good stat scaling that you can keep with you and level up for a long time, ideally all the way to the end. Watching my friends use it and going from my own experience, it trivializes the weapon upgrade and stat scaling elements for most of the game's beginning, systems you ought to be familiar with as soon as possible.
From what I understand about the stats in this game, it's better to pick equipment you know you want and spec into it so that as you get stronger, so does your weapon. I could be wrong, though, that's just how it's worked for me.