with all automatics never ever ever get them flushed, just drain and fill that’s plenty enough. as for mileage intervals id do cvts and dcts every 30-40k miles, however the upper end for pretty much all autos is every 60k miles. if you’re looking for official recommendations good luck, many automakers don’t specify transmission mileages anymore as they claim the fluid is “lifetime” which is definitely not true. but stick to the general rule of thumb of 30-60k miles depending on transmission
look at tires and wheel bearings first those are the two biggest causes. certain tire treads can make more noise, but check to make sure they are installed correctly and that they don’t have weird/uneven wear. if they have uneven wear, that points to an alignment or suspension issue. if all checks out on that front it’s most likely a wheel bearing