This is from a study of youth swimmers, so it's not completely generalizable to basketball, but one expects that the answers would not differ too greatly among children of the same age in different sports.
https://www.teamunify.com/akkkw/UserFiles/Image/Links/kids_tell_us_what_fun.pdf
TOP 10 SOURCES OF FUN FOR AGE GROUP SWIMMERS
Source of Fun
1. Being with friends*
2. Coach compliments and encourages me
3. Being known as a good swimmer
4. Winning races
5. Getting in shape
6. Varied workouts
7. Relays where team comes together*
8. Feelings of accomplishment
9. Cheering for each other/coming together as a team*
10. Trying to improve my times; Being on a team*
TOP 6 REASONS SWIMMING IS NOT FUN FOR AGE GROUP SWIMMERS
What is Not Fun
1. Getting slower times than my goals
2. Getting lapped in races
3. When other swimmers skip laps or get in front of me
4. When coach yells or threatens me
5. Swimmers who think they are good just because they are fast
6. Parents ask about bad races/When parents brag about their swimmer
IMPLICATIONS FOR COACHES
Recognize fun can be incorporated into practice without detracting from it Promote a team concept
Steer clear of what is “not fun” for swimmers Be aware of the need to provide external fun for younger athletes Ensure the social aspect is present for females; Talk with males about self-referenced success Work to enhance each athlete's perception of ability