An eSIM is just software you download to your phone while you have access to reliable WiFi (at your hotel, before you leave home, etc.). The eSIM will not affect photos, web surfing, etc. You do not need to remove your current physical SIM; you just turn it off via Settings on your phone. Note: Not all phones are eSIM-capable. You should be able to determine whether yours will work with an eSIM by Googling the model number.
Be aware of what type of eSIM you are buying. Most provide cellular data only, in which case there will not be a telephone number connected to the eSIM and you won't be able to make or receive calls (unless you use some sort of WiFi calling software).
No phone number on an eSIM means if you want texting capability on an Android phone, you have to use your home SIM for that function, so you need to check to see what your regular phone plan will charge for that. I have Google Fi, and texts are free. The way my phone works is that incoming texts arrive as usual, but when I install a new eSIM and go through the (usually simple) activation procedures, my ability to send outbound texts initially disappears. I end up doing a bit of fiddling (turning my home SIM on again, but being sure the eSIM is set as the primary SIM) to get texting capability back. On my Samsung phone I then need to select my home SIM for texting to each contact I want to text. (Fortunately, I don't text with very many people.) Other brands of phone may allow you to change just one setting to make your home SIM primary for texting; you'll be able to find the information by Googling, but it may take a bit of patience since phones vary.
Because I keep my home SIM turned on (but not for data usage), my phone number remains active, and calls can come in. I pay only about $0.25 per minute for phone calls, so if I get one occasionally, it's not a big deal. I can also make outbound calls if I need to. There are eSIMs that give you a new phone number if you need to make calls.
Important: You wouldn't want to use your home SIM for texting if it results in a daily charge. In that case, you should explore an alternative like WhatsApp, which requires WiFi. You can play around with WhatsApp before you leave home; be sure your regular contacts have it on their phones. (It's free.)
I used Airalo eSIMs very heavily during lengthy trips this summer and last. Other than the fiddly business with texting, I've only occasionally had issues. They usually seemed to be related to network reliability of the local telephone company. If you use a mapping program that requires internet connectivity, as I do, it's prudent to recognize that you may occasionally not have a signal. Whether that's a problem with the SIM or the internet server you are hitting, I do not know, but the problem occurs for me sometimes when I'm walking around Washington DC, where I live.
The activation steps for an eSIM can vary a bit, but it's usually simple. If my phone doesn't give me internet access within just a few minutes after I switch to a new country/eSIM, I check the settings on my phone to be sure I've made the eSIM primary, etc. If everything looks good on my end, I restart the phone. That normally solves the problem. I had a Nomad eSIM for one of the Balkan countries that I never could get to work. It could have been user error, but I decided to walk away from the less-than-10-euro expenditure and just stick with Airalo.
I'm sure you can find videos about activating eSIMs on YouTube. Try to find one using the phone model you have. It's really not difficult. If there seems to be a problem, I just take a deep breath and review the instructions (which can vary by eSIM) rather than panicking. Your home SIM will still be in the phone, so if you get in a bind, you can always turn it on and make it your primary SIM; you'll just have to pay the daily charge until you turn it back off.