This is quite an easy one. Yes. One overdrive may be enough for some, but there’s a really broad canvas of tonal options and most overdrives won’t be able to fill all of that, so the likelihood is that there is always room for a second overdrive on your pedalboard.
The other excellent thing that you can do with overdrive pedals is stack them, with one effect cascading into the other. This can result in entirely new tones that are perfect for lead sections, or heavier moments. Some manufacturers will even do this for you, for example JHS’s Double Barrel features the circuits of both its Morning Glory and Moonshine overdrives, which can be run in series, including flipping which order they are placed (either can be first or second).