It's already been mentioned a couple of times, but here's another LEGO game recommendation.
Several of the LEGO titles are
currently on sale. They certainly fit the "shared experience working together accomplishing goals" concept and aren't exactly violent or gory. I'd recommend picking an IP the both of you like and going with that.
But if you just want to test the LEGO waters, and if you didn't get the LEGO: Batman Trilogy from the Epic Games Store a few months back, the first LEGO: Batman game is only
0.99 on Green Man Gaming.
If you subscribe to
Humble Choice, this month's selection has two non-gory, goal-focused co-op games as part of it:
Trailmakers
Unrailed!
Subscribers to Humble Choice get access to the
Humble Trove, which currently includes Trine: Enchanted Edition, a co-op platformer/puzzle game. It's rated E10+ for fantasy violence.
Lastly, here's an unconventional co-op recommendation. For an experience that's a bit more challenging but will bring about more communication, teamwork, and interesting decision-making, I nominate
Star Trek: Bridge Crew. It works without VR and supports 1-4 players. You could have one person playing as the captain and the other player switching out the remaining station roles, or have both switch out as you like. AI will fill in if a role isn't directly controlled by a player. The game is rated E10+ for fantasy violence, with starships shooting at each other and getting blown up, like in the shows and movies.