Can the phrase small frame and big name be considered an oxymoron as in small in stature with a long last name?

No. An oxymoron is the combination of two words that have opposite meanings, while someone being small but popular is quite possible. Examples of oxymorons: same difference; jumbo shrimp; living dead; open secret