GH-35806: [R] Improve error message for null type inference with sparse CSV data

GH-35806: [R] Improve error message for null type inference with sparse CSV data #91014