It all depends on your interests, needs, wants and how active or lazy you are.
SDR's and Scanners can easily compliment each other.
SDR's are ideal for hobbyists that like exploring the spectrum and the hunt for transmissions.
Starting from scratch to build unknown systems using SDR's can be frustratingly enjoyable for active minded people.
SDR's make it easier to identify transmissions and piece together unknown systems.
SDR setup can be confusing for some, but when you know how, it should take 2-5min max on Linux or Windows to crack on exploring.
Unlike a scanner, an SDR with the right software can be used to receive and decode a huge array of data signals.
For those with no patience, are lazy or have no desire to experiment, then SDR's are definately not your thing.
Although there is the real lack of portability, a hobbyist probably has an eye for various options to make great portable SDR to-go kits.
Scanners are perfect to have as a base unit, have in your vehicle, or on you in person in your pocket using discreet headphones.
They are also suitable for those that find newer technology challenging or confusing, or just want something that requires little tinkering to work.
Using RR DB is a convenient source for those living in the USA - enables you to download and listen to known networks in your area with little effort; however, the configuring of scanners for unknown networks can be lots of trial and error.
For those outside of the USA, RR DB is next to useless as no scanner has the capability to download network data of countries outside of USA; however, some countries have options locally to purchase pre-configured SD-Cards that contain known popular networks for their local area.
It all depends on what you want to do - just listen (Scanner), or to experiment and listen (Scanner and SDR).