How reliable is an SD card that size?

They're no less reliable than 128GB cards. The bottleneck is likely going to be whether the phone's filesystem can actually index 1TB worth of files without crashing. No such problems on a real computer.