Flight home is delayed due to storms so I notified my boss, he offered to drive 11 hours here to pick me up and 11 hours back??

Isn't that sort of uncomfortable? Would I be wrong to refuse and take a flight, even if it's cancelled and I miss another day of work? I mean I sort of appreciate the gesture… How do I phrase my refusal?