As a small Division III school, Pomona doesn't put that much emphasis on athletics. Some of the sports are taken pretty seriously, however, particularly football, baseball, basketball, track, soccer, and rugby. The varsity athletes do get very involved in their sports and are often somewhat cliquish, but general student support and interest are relatively low. Athletes tend to attend the games of other athletes. Some intramural sports, such as ultimate Frisbee and inner tube water polo, generate a fair amount of excitement, as well.
If it is important to you that you be worshipped on the basis of your athletic might and main, then don't come to Pomona. You will not be worshipped. You might be some coach's sweaty dream embodied, but don't let him or her trick you into thinking sports here are all that important. Most students care about as much for sports as they do for any club or activity that they aren't involved in. "Polite disinterest" would be a good way to characterize their feelings. No one's going to look down on you for grunting and knocking heads with your testosterone-dripping cronies, but they aren't likely to ask for a signed jock strap either. That being said, Pomona has a perfectly respectable athletic program for a Division III school, and there are plenty of opportunities for sports at the college. Football is really the only sport that gets any recruiting power, though.