@empacher48 You might be right for the moment, but looking at my daily job at that mentioned "A-manufacturer", I ask myself if I'll find more than one pilot on the FD in the near future.
A colleague of mine is working on this (reality): https://lilium.com another step in the direction of automated flight.
(And yes, I'm rated and allowed to drive from LH/MID seat as well.)
With all due respect to your friend the aircraft your link goes to is nothing more than an over grown remote control aircraft. What range, payload does it have and how much noise does it make?
For the time being and for the foreseeable future there will be two pilots up front. Will there be ever just one, possibly. Will there be ever none. Not in our lifetimes I suggest. The cost of the technology, passenger resistance and insurance companies will dictate when and if ever it occurs.
Even though having one pilot is doable there are some logistical issues. The Captains have to get their experience somewhere, right now their operational experience comes from their time as a First Officer. If there's only one pilot where will they get that experience? There's only so much that can be done in a simulator.
To address the OP.
There's no point in dying wondering what if. Though you do need to rationalise the costs V benefits. If you don't need the money to live on then don't hesitate, it can be a very rewarding career (not necessarily from a financial perspective).
A job as a scenic flight pilot means you won't be able to live in many of the places you mention as there is virtually no tourist flying done outside of the main tourist hotspots. You will need to choose what type of flying you want to do. You will need a CPL no matter what you do. You might want/need to get an Instructor Rating. If you want to fly for a company doing any sort of regular passenger service you will need an Instrument Rating.