The reason they need to spend millions at Headingley is to ensure continued test match status. The ground has provided a suitable home for what is still the best county club (Yorkshire still have more county championships to their name than any other county by a wide margin), but someone somewhere has decided that in order to qualify for hosting test matches these days a ground has to have a certain number of specific facilities.
I do agree that the relatively low attendance at this match is disappointing. Yorkshire always used to have a very keen army of supporters but, for some reason, they've not been coming to this match.
I also agree that we should go back to the six traditional venues: two in the North, two in the Midlands and two in London. That seems a fair spread and provides somewhere to go within a reasonable travelling distance for most people. We could, of course, make use of every county ground but that would dilute things too much and mean that each ground would host test matches much more rarely.