Nah fam should be great along with your 400W PSU.

i have the same question but yes it will bottleneck your GPU as FUCK, so you and me gonna have to literally change everythingin your pc from CPU to Mobo to Ram and maybe cooling solutions for the different sockets that comes with later CPU's and even you PSU, as 3090 will draw as high as 550-600w off the wall at load. 

https://www.tomshardware.com/features/nvidia-geforce-rtx-3080-ampere-cpu-scaling-benchmarks



PS, i also had specs similar to yours 2 years ago 4790k, Z97 Gaming 5 MSI, 780ti Asus DirectCU II, Corsair Hydro Series™ H90, but i changed out my GPU ti 1070 strix later.