It’s the same thrill as any other game or sport. Many enjoy the challenge of trying to do something difficult and get better at it, and then enjoy doing it competitively, and/or cooperatively with friends.
In the case of golf, you also get the added enjoyment of it being a generally slow paced activity, usually done on a beautiful day in a pretty area with lots of grass and trees.
A fair trade (startrek.website)