Nothing about a gym membership or even having a full home gym will take the place of motivation. Not having equipment often becomes an excuse, and once we have it, we move on to another excuse. There must be some introspection and commitment on your part. If you struggle, I would suggest a professional (personal trainer or dietician) who can help you set goals and understand the why behind them.
Consider subscribing to the
@V2Pnutrition podcast. Consider an activity tracker (this has helped me, but does not help every one). Consider a gym membership (they have showers, so you can rinse off before hand.
For me, stationary equipment becomes boring. Having a bad weather option can be nice, but I have found I'm more likely to go to the gym than I am to use a rowing machine in my living room when the weather is bad. Some of this is having small kids at home (which I don't think applies to you), but honestly I had trouble being consistent with it before I had kids. For me, I enjoy running, and for training for a marathon nothing can replace running.
Don't let what you want to do get in the way of doing something. For example, once I build up my training distances, I start wanting to run for 2-4 hours ever time, but it is hard to carve out that much time from a day. This usually leads to a tapering off in my training, however if I accept that a 30 minute run is better than no run and stop worrying about pushing distance, I would be better off.
Good luck. There is little more beneficial to long-term health than exercise (done thoughtfully, without over training). Clean up diet at the same time and over 6 to 12 months the results can truly be life changing.
My advice for today, start taking a 15-30 minute walk every day at a brisk pace. Start working on the discipline of making time now. If the weather is bad, get the proper clothing. If it is icy, get microspikes.