i have several which I often switch daily. They don’t take up much space so taking them is not a problem. Really big cards are often more expensive per GB and now you have a single failure point. Even reviewing pictures on the camera is a pain if you have too many.
Obviously this changes if you do 4K or 8k video. There a 1 TB is probably very useful.
of course when talking about storage you don't usually buy the largest capacity available if you are worried about money... same goes with hard-drives... you buy 8TB even if 10TB are available, because they are cheaper by the TB... but that should make 200GB and 512GB sd cards cheaper, at least
Obviously this changes if you do 4K or 8k video. There a 1 TB is probably very useful.