lots of low power RF SOCs out there at the moment.
Ti are pretty good. All I would say with them is stay away from their 8051 core models, as they have had their day... But both the ones you are interested in are ARM so all good. I haven't used either of these yet, but I'd not be afraid to.
As far as battery goes, you can definitely have lots of modern RF SOCs making a product that will live for years on a coin cell... but you need to think about your application and your data transport requirements.
If your processor needs to do lots of intensive processing or very frequent sampling of sensors and can't stay asleep 99.99% of the time, of course that will be a problem.
Or if it has a long RF activity time (say, like transmitting LoRa with the data rate wound way down to get huge coding gains, or even something else with a protocol where you might have to stay listening for extended periods to catch a message from something else, even just for getting the network up first time) you need to be careful with coin cells.. because with coin cells drawing over their rated current, even for a reasonably short time (20 seconds or so) you can badly derate them from their expected mAh lifetime.