Self‐esteem trajectories across 25 years and midlife intimate relations