Easy OS installation and experimentation by swapping SD cards is a neat feature made possible by this design choice. You can improve durability by underprovisioning - SD card of 64 GB capacity costs a dozen euros or so. Judging by the popularity, RPi isn't generally seen as pointless but certainly it's not the best option for every application.