Stardew Valley is co-op and it’s farming/life sim.
There’s a lot of factory and resource management games that are co-op and not intense. I personally recommend Satisfactory.
If you’re looking for some combat without stress, Elder Scrolls Online is very co-op friendly.
Bungie did this 100% to themselves. An MMO like Destiny is going to face attrition, but they really shot the selves in the foot by making it the worst experience for a returning player. It’s confusing, grindy, and stupid expensive.