Bloody hell! So you've gone from potential drive shaft replacement (again) to actually it was the tyres.Update after having had the new tyres on for 1200mi - the whiring drone was the old PS4 tyres.
This is a prime example of eliminate the simple items first before thinking it's catastrophic. Good effort and feedback max2ksr!