Whilst the split between perl/lib and perl/site/lib has always seemed entirely pointless and arbitrary to me

Well, it does allow you to get to a pristine core installation in seconds. Yeah, it's of limited value. But who cares.