Anybody on here do any distance cycling?

After many years of being idle, I have started try and do sports including football, badminton and now im going to take up cycling. I had a bike for years, but never used the thing. Last night I went for a bike ride and done about a 6 mile round trip, the trouble is my backside is in agony from the ride. Its started to hurt after about 2 miles and today it is pretty damn sore. I used to ride this bike constantly in the past (many moons ago) and never had any issues. I have been advised to get cycling shorts as they are padded in that area, but I cant imagine they have the most flattering look for someone of my slightly rotund size . And they aren’t the cheapest of things!! I used to bike everywhere as a **** and never remember having this much hassle.

Its off putting and demoralising because im trying to get fit, but with every sport I do I get some form of injury or pain. Any advice on how to overcome this?