I suppose you could ask the same question about any software category where commercial and FOSS options exist. The short answer is that SQL Server is "the right answer" for some companies, after analyzing the long list of technical, financial, and support pros and cons.