I believe that the Rogues Sneak Attack ability can only be used with ranged and finesse weapons is because those weapons rely on dexterity for their attack rolls which means that they are aiming with these weapons at vital spots. Hence the sneak attack. Whereas a longsword relies on strength...