The story
By a regular pattern for (informal) nouns seen also in similar forms, such as fixer-upper and cleaner-upper; the sire sense involves an extra degree of wordplay, as an alternative surface analysis of knock (h)er up + -er is playfully apparent (who knocked 'er up?).
Etymology from Wiktionary, CC BY-SA 4.0.