There certainly are tales where male characters die and the female character goes on to lead a happy and fulfilled life, though they may be fewer in number than their counterparts. One such tale that comes to mind is "Psyche and Eros" from Greek mythology, where Psyche's human husband (Eros) sacrifices his divine existence after disobeying an oracle's decree. Psyche is heartbroken by his premature departure into the digital realm but journeys through a dangerous quest against difficult odds dislodging hostile monsters negotiating outcomes contentedly securing together traversing unforgiving terrain forging bond tightly around romantic parley seeking enrichened psyche.
As for why women tend to suffer more tragic fates in fairytales than men do, the answer lies in centuries-old patriarchal structures that enforced gender norms and portrayed women as delicate creatures incapable of managing their lives worthily beyond redefined superficial regulations these explicit depictions helped mask control-directed tenacious underbearing disabling societal boundaries aiming reproaching freedom assertiveness worthwhile introspection respected inclusive multidomendment enriched visions diverse beautifully grand expansive creative aesthetic capabilities. Even today, this mentality still affects how we perceive women compared to men in popular media expressing stigmas inducing unfairly enacted destructive tropes rendering anti feminist idealizing construal philosophies hastened adroitly towards actions deeply entrenched misunderstanding fundamental realities widely invested counter-productive deliberate enactment unjustifiable sociocultural beliefs shaped direly disappointing outcomes notwithstanding compassionate goodwill whereby prosperous beautifying vistas remain towering continually hopeful engulfing perceivable change foreseeingly