Yes, that is entirely possible. A friend and I have breezed through C1 and C2 relic sites with a drake and a hurricane. If you loot and salvage the site you can make pretty good isk (Don't have exact numbers, as most our experiences were day trips where everyone just kept the loot they grabbed). If someone has a data/relic analyzer you can make a good deal more. Remember, sleepers don't have bounties, so if you don't loot the site, you'll come away empty handed.

That being said, there are plenty of dangers that must be dealt with. Without local, you have no idea who is there. As soon as you enter a wormhole, the first thing you should do is check long range D-scan and see who is nearby. If you see ships and you aren't ready for PvP, find another hole. The whole time you're in a WH, you should be constantly checking D-scan. If you see ships or combat probes, chances are you're being watched and hunted.

Also be advised that WH rats will neut you. It's not too bad in a C1/C2, but an active tank that isn't carefully managed can quickly be broken if you don't focus the neuting ships.

Make sure to bookmark the hole you came in. I can't count how many times I've made this mistake and had to scan it back down again. While this is usually just a minor nuisance, it can be a serious problem if you're trying to escape hostile players.

Finally, as always, don't fly anything you can't afford to loose. If you fly in wormholes regularly, you will lose ships. It happens. Just grab another and try again!

Good luck!

Daytrips is a good way to test things before setting permanent presence in w-space. But remember that if you want to make more isk than from hi sec missions you have to go at leaset C2 with C3 static and set up pos. Up to C2 drake is perfectly ok but anything with enough tank to handle sites and more dps will make it faster.

Any suggested drake fits?

something like this https://forums.eveonline.com/default.aspx?g=posts&t=301913. For C2 you need around 400 tank which is most comfortably achieved on passive drake and as much dps as possible.

Highly advisable to make use of the mobile depot so you can refit to do hacking or looting or scanning.

C3 anomalies run quickly bring in income very comparable to Incursions (100M ISK/hr). For the solo artist, C3 wormhole income in a T3 is a fine end-game. For the small group of sub-capital pilots, C4 is a little better, but not hugely so. C5 and C6 capital escalations provide unreliable but extreme income possibilities, typically something like 4Bn/hour... and huge competition for that resource in the form of mandatory, frequent PvP.

But please please please, start out in a C1 or C2 and work on your scanning/combat skills. DO NOT do what I did and just jump into a wormhole corporation...

I'm going to slightly disagree there. I'd say jump into a wormhole alliance with a C1 or C2 wormhole training corporation. You'll learn the basics of POS mechanics, scanning, running sites, mining, differences between kinds of sites, gas harvesting, etc. and get both time to skill up to the specifics you'll need for wormhole life. Worth it.

There are a number of wormhole alliances that have such training corps. C2 life with daily training can provide a reasonably good income while building your character and real-life skill at the game. Look in the recruitment center.

Not sure if this is possible for you, but if you have an alt that can cloak, put it on the high sec hole. Then, turn down the volume on your site running account and turn it up on your cloaky alt. Make sure to have your alt's camera focused on the wormhole This will allow you to hear a wh activation without having to constantly check the other account. It makes for a nice warning system if someone decides to jump in the system from high sec. It has saved me a ton of times.

Not sure if this is possible for you, but if you have an alt that can cloak, put it on the high sec hole. Then, turn down the volume on your site running account and turn it up on your cloaky alt. Make sure to have your alt's camera focused on the wormhole This will allow you to hear a wh activation without having to constantly check the other account. It makes for a nice warning system if someone decides to jump in the system from high sec. It has saved me a ton of times.