There will never be another underground waste repository in the US after this. For if we decided to pick on North Dakota, they would follow the Nevada recipe to get out of their obligations. As well, no site can be 'certified' for one million years. And the transport issues will be the same.
Nuclear waste will continue to be sent to scrapyards, and stored in rusty barrels by rivers flowing into cities. As usual, there will have to be some sort of disaster to start things going again.