Apple discontinued their last Intel Mac around the end of May, beginning of June, 2023. That last Mac could get new MacOS upgrades for five years from that point. As long as there is one Intel Mac that gets the latest OS, the other Intel Macs can probably be patched. There may be Intel Mac updates until 2028. And even then, it takes 2-3 years before the last OS is too old. If you're okay with using a patcher, Intel Macs are not dead yet. Which plug-in developer will be first to cut off some of their highest-end consumers using Intel Mac Pros? It will happen, but I think that is still 3-4 years off. Maybe longer.
But, Apple Silicon is great. Beef up on RAM, skimp on storage if you have to choose. Or, just get the machine you want: pay once, cry, and just use your new machine for a long time. Quiet and cool. They're really great.