Absolutely. It was meant to replace the B-52 but the B-52 is likely to outlive it.
I'm not really even sure how it is an improvement on the B-52 anyways. The listed payloads on Wikipedia is higher than that of the B-52, but I'm not sure I trust those numbers.
I don't think it much matters that it is supersonic. The US enjoys air superiority in all conflicts by virtue of it being the only one with planes in the air. Perhaps it is slightly less vulnerable to SAMs due to its speed advantage? The US is pretty good at neutralizing SAM installations using missiles, long before any planes get over the battlefield.
I don't see how the B-1B can fit into a modern military.