You might all have valid arguments on a technical level.
But you have to take two step back and not get tangled into technical subtleties and just use common sense.
It all comes down too:
Let's say we have 1000 random Debian users performing a new server installation.
999 of these will not use optical media (CD-ROM/DVD) and will have a broken package-configuration (out-of-the-box) and will need to take special steps to get it working (modifying the sources file).
The last 1 of these will have a well working system.
Please design Debian to target the vast majority, by fare, of installations scenarios by NOT putting CD-ROM as the 1st priority package source in the sources.
I would not be surprise the actual ratio is 1.000.000/1.....a USB flash drive with room for 5GB iso is way cheaper today than buying recordable optical media (if you can even buy them). Which only make it even more absurd the out-of-the-box configuration is targeting this 1 user!