Karen,
Many single digit handicappers can move it out there but the percentages are very low. If you hit the ball 250 yards off the tee you are hitting it very far relatively speaking, easily in the top 10% of all golfers. If I am honest with myself, I average in the 240-250 yard carry range and after that the roll I get depends on the firmness of the turf. I can get it out there further but that requires the perfect strike. A hole like Riviera #10 tempts someone like me to make that career drive to the front edge of the green. Most times, however, I will likely end up in the awkward 20-50 yard range with the need to flop something over that front bunker to a very small target. Not ideal which is why a smarter play is to leave a full shot where I can get some spin. But this is why the hole is great because it is so short that it plays on one's ego and confuses better judgment. Even for the golfer who knows they can't reach (which is most) they have a hard time not giving it a go 😊