Does distance from target affect paintball splat size?

No. Only if you are VERY far away, the paintball may not break at all.