FPGAs are neither here nor there and will always be niche. If you need the same thing many times you make dedicated silicon. If you need many different things available all at once you use a normal CPU. Only if ASICs are too expensive and CPUs are too slow the FPGA can shine.