If you've played any type of competitive sport and enjoyed the camaraderie, then you will love playing tournaments. Meeting new people who will become life-long friends is far more important. I started playing in the summer of 2004 and played my first ice bowl in February 2005. Scariest decision I ever made. Got up early on a freezing cold morning, drove to a course I'd never played before, to meet and play with people I'd never met. I'd played random doubles the previous summer, but tournaments were a whole new thing. That day I met about 2-3 dozen guys that I still play tournaments, random draw doubles, and New England Team Challenge matches with ... and it's 12 years later. Best decision I ever made. I was 27 and single then. I'm 38 now, married with two kids, and MANY of those guys have gone through the same changes. That's what disc golf is really about. Enjoying and talking about life with people who are going through the same stuff as you.
How you actually play is secondary. Don't get me wrong, sweating how you will play will keep you up the night before, and how you play will keep you up for several nights after. But the friendships you make will be worth all of those sleepless nights.
Jump in!!!