Superiority of Softmax: Unveiling the Performance Edge Over Linear Attention