Power consumption is a major draw (pun intended) to keep Pis and other SBCs of that kind of form factor employed.
To me arguments like "2W vs 10W" are fairly meaningless.
I am much more concerned about data center power usages, especially in the age of LLMs.
Like that ancient German teacher I had that kept preaching we should stop using electric kettles because it's bad for the planet. While the 3 plants in her hometown amounted to ~83% of all power usage and ~92% or all pollution. Boy, was she unhappy when I did that research and pointed it out to her.
Pi-s / SBCs are I suppose very good for computing out there in the meatspace, where you might need a battery because sometimes power stops for 6 hours? Could be that.
She was, shall we say, disappointed with the response.
Also this was some 15 years ago.