I would argue the reverse is also true. There were famous people with intimate relationships that have very unfulfilling lives.

My assumption would be many of the people you're referencing are/were either on the aro/ace spectrum or simply closeted homosexuals.

Most people desire intimacy, and will experience some amount of discomfort/distress from a prolonged lack of intimacy. See also "touch-starved." It is also perfectly normal for individuals to find themselves on the aromantic/asexual spectrum, where they may either not need intimacy or may even find displeasure/discomfort/distress when engaging in intimacy for another's sake. These are things that are important to keep in mind when discussing other's needs and desires or lack thereof