We have had USAF exchange opportunities in the F/A-18 for decades, and reciprocal USN exchange opportunities for USAF folks to come to the F/A-18. The USN billets for USAF pilots are primarily non-operational, so they wouldn't involve carrier ops. If you go back about 20-25 years, there were a few limited jobs within operational EA-6B squadrons for USAF pilots that actually did go to the boat, and then that all got shut off in around that timeframe (early 2000's). They continued to send USAF back seaters to Prowler boat squadrons, but not pilots. I'm sure there has been a USAF pilot go to a USN F/A-18 boat squadron, but I don't know of any during my career. What mover did was the more typical assignment to a reserve adversary squadron, in his case specifically VFA-204 out of NOLA. So he did his Hornet tour there, and as you/he mention, they did not operate off the boat anymore by that point, as the Navy reserves mostly got out of the operational side of things by the early 2000's (when we got rid of reserve numbered airwings and a bunch of reserve squadrons)......only VAQ-209 still remains, on the tactical aviation side, and they do land based deployments exclusively.
*of note, we actually did recently send the first USAF pilot to a USN VAQ/Growler boat squadron. I don't think there will necessarily be more, they just were so critically short manned that they needed the help. Up until then, AF people in VAQ go to land based/exped squadrons only.