The main role in Pretty Woman was offered to many celebrities. Daryl Hannah, for example, said that this role would be humiliating for a woman. Michelle Pfeiffer, also turned down the offer to play this role. She told the director that she didn’t like “the script’s tone.” If Pfeiffer had agreed, then it’s likely that Vivian would’ve been a blonde.
At the same time, the young and comparatively barely-famous, Julia Roberts decided to try herself in this role. An obvious “chemistry” appeared between Richard Gere and Julia on their first meeting. Still, Gere didn’t want to take part in this movie and was already getting on the phone to relay this message, when Roberts slid him a note with the words “Please say yes.” And he agreed.
He didn't read the script beyond saying he didn't want to be on screen with a bunch of dwarfs.
Close friends said he never got over it, and essentially retired from acting.
That's strange considering Sean Connery did a lot of wacky off the wall films throughout his career. Consider Darby O'Gill and the Little People, Sir Gwain and the Green Knight (odd af) Time Bandits with actual little people. Those were some odd choices for the former Bond ha ha.