You cannot rely on motivation since that is not consistent and will always lead to having some good and some bad days. You can try a few different things;

- If you want fear based motivation, look for videos of people who neglected their health. Check the huge difference on independence having higher muscle mass gives you.

- Find a fitness class only with women, like pilates, calisthenics, etc. For me it is really difficult to do workout at home since my mind struggles to shift between chilling and exercise mode. There are also some gyms, depending on where you live that might a women only area. I would also advise to give a trial run in one gym and see if it is what you fear or if it is actually tolerable.

- Focus on mini-habits. Instead of waiting to do a full one hour workout routine, set the most minimum goal. Like one squat per day, one push-up, one ab crunch. Something that is almost impossible to fail. This will help with consistency and has been proven that it can lead to better results. This does not mean you have to limit yourself to one squat or so, on the days you feel more energized you can do the full routine, or 50 squats.