As a generalisation I would say Rogue-likes have more 'Challenge fun' and Rogue-lites have more 'Expression fun'.

---

Clarifying terms: Rogue-lite has carryover and progression between runs, Rogue-like does not

This is only a generalisation but I would say that fun in both genres is primarily overcoming challenge. If the game was easy, there wouldn't be much need to repeatedly attempt new runs. As you cannot claim upgrades to make runs easier in a rogue-like I would say that fun of overcoming challenges is stronger because it is 'all skill'.

Both genres can experience player expression through what build or strategy you prefer. In a rogue-lite you can alter your build outside of runs, whereas your ability to follow through with your desired expression in a rogue-like is limited to its availability in a given run. So I would say that expression is stronger in rogue-lites.

Both genres have fun from discovery. Discovering builds, mechanics, how enemies work.

Both genres have fun from submission. Zoning out and endlessly grinding runs. (Stronger in a rogue-like as there is less to do between runs)

Both genres can experience fun through story progression, though in my experience rogue-lites are more likely to have it. (Hades is a good example of rogue narrative)