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