I have the opposite opinion:
Several new features in Logic Pro already require Apple Silicon.
And _if_ Apple stops releasing support for Intel in the next version of macOS 2025, which is not unrealistic based on the timing for the PowerPC->Intel and 32->64 bit Intel transition, that could mean that in 2026 Logic Pro would no longer support Intel CPUs. That is 2 years from now! You could still _use_ your Intel machine, but it will fall behind quickly.
Rosetta works fine and is fast. If necessary, you can use it without any issue, e.g. right now that would be ARA.
I have decent knowledge of tours and musicals using Macs. All of them are using Apple Silicon based machines for years.
You should not buy an Intel-based Mac, except if you _have_ to. But you are not a commercial studio, which might keep some old hardware around – some studios even have some Atari ST for that reason. But even as a commercial studio: you do not want your business being depended on hardware, which you can only buy used. Compatibility with a specific 32-bit Intel Plugin is a complete waste of time for you. Do not invest any money or time into anything that has not full support of Apple Silicon. Why? If a vendor has no 100% support of Apple Silicon after 4 years, they clearly do not care. Why give them money? Why bother with compatibility issues, which will come up?
You should not spend money on something that has no future. Look into a used M1/M2 MacMini with at least 16GB of memory. If necessary: wait a little bit longer before upgrading.