Yes it is possible to replace all electrolytic caps with MLCCs. There are some things you'll have to consider in your design, but it is possible. And yes, the lifetime will be greatly increased in most cases, but even with electrolytic caps it is possible to build very reliable switch mode power supplies.
While it is true, that MLCC offer a more reliable solution to filtering the output, most product designs are driven by cost and space.
MLCCs are far more expensive per capacity than electrolytic caps. I haven't found a 47µF/450V MLCC, but a search on Digikey turned up with some points:
47µF/25V MLCC - 0.28$ @100k
47µF/25V aluminium - 0.05$ @100k
So the aluminium electrolytic cap is only a sixth of the cost of the MLCC. And these are quite low requirements, it gets very very worse for higher capacity and higher voltages.
Another point which should be made is, that if you actually need 47µF @25V, you can't use a MLCC which is marketed as 47µF/25V cap, as the capacitance of (some) dielectrics used for MLCCs are extremely voltage dependent. Let's take a look at one of those datasheets for MLCCs(page 54). As you can see, the capacitance at the rated voltage is only half of what is advertised. So you basically need two 47µF/25V MLCC for 47µF at 25V, which doubles the costs for MLCCs.
Yet another point which might go wrong with MLCCs is the piezoelectric effect, they can act as microphones or vibration sensors and give off additional noise into your system. Or even emit some sound if the ripple frequency is in the right spot.
If you are aiming for really long lasting power supplies, you will increase safety margins on every component, so you make your capacitors bigger and suited for a higher voltage and most importantly rated for higher temperatures. If you combine that with good thermal management, you can go a long way even with electrolytic caps.
Still, from my experience people in the industry tend not to buy a really really expensive thing which is advertised to last forever but rather like a redundant solution. So they'll buy two normal sensors, two normal power supplies and if one fails they will replace it. It's in most cases much more cost efficient to do so. Also the question always arises: How much can you trust the manufacturer to really make a "lasts forever" product.
So in the end, there is only a really low demand for super expensive, super reliable switch mode power supplies, so you never see them. I'm sure they are around somewhere.